Snapshot
From DreamFactory
snapshot_t
Table definition as of 2015-09-18 11:28:46
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| id | bigint(20) unsigned | NO | PRI | auto_increment | select,insert,update,references | |||
| user_id | int(11) | NO | MUL | select,insert,update,references | ||||
| instance_id | int(11) | NO | MUL | select,insert,update,references | ||||
| route_hash_id | int(11) | NO | select,insert,update,references | |||||
| snapshot_id_text | varchar(128) | utf8_unicode_ci | YES | select,insert,update,references | ||||
| public_ind | tinyint(1) | NO | 1 | select,insert,update,references | ||||
| public_url_text | varchar(1024) | utf8_unicode_ci | NO | select,insert,update,references | ||||
| expire_date | datetime | NO | select,insert,update,references | |||||
| create_date | datetime | NO | select,insert,update,references | |||||
| lmod_date | timestamp | NO | CURRENT_TIMESTAMP | select,insert,update,references |
