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