SQL
CREATE TABLE `checkins` (
`id` integer,
`license_id` text NOT NULL,
`machine_id` text NOT NULL,
`created_at` text NOT NULL,
`ip_address` text NULL,
PRIMARY KEY (`id`)
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
INTEGER |
Rename | Drop | ||
license_id |
TEXT |
Rename | Drop | ||
machine_id |
TEXT |
Rename | Drop | ||
created_at |
TEXT |
Rename | Drop | ||
ip_address |
TEXT |
Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|