file-market
Tables (4)
Untitled (users)
- id — int — Primary key — NOT NULL
- name — varchar(32)
- login_id — varchar(32)
- password — varchar(32)
- email — varchar(32)
files
- id — int — Primary key — NOT NULL
- name — varchar(128)
- created_time — datetime
- modified_time — datetime
- deleted_time — datetime
- folder_id — int
- favorite — boolean
- trash — boolean
- user_id — int
folders
- id — int — Primary key — NOT NULL
- name — varchar(128)
- created_time — datetime
- modified_time — datetime
- deleted_time — datetime
- favorite — boolean
- user_id (Field2) — int
notification
- id — int — Primary key — NOT NULL
- user_id — int
- message — varchar(512)
- url — varchar(256)
- is_read — boolean
- created_time — datetime