mybox

Tables (4)

Files (파일)

  • id (Key) — Long — Primary key — NOT NULL
  • folder_id (폴더ID) — Long — Foreign key → Folders.id — NOT NULL
  • user_id (유저ID) — Long — Foreign key → Users.id — NOT NULL
  • volume (저장공간) — Long
  • created_at (생성일자) — localdatetime
  • updated_at (수정일자) — localdatetime

Folders (폴더)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (유저ID) — Long — Foreign key → Users.id — NOT NULL
  • volume (저장공간) — Long
  • created_at (생성일자) — localdatetime
  • updated_at (수정일자) — localdatetime

User (사용자)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field)

Users (유저)

  • id (Key) — Long — Primary key — NOT NULL
  • name (이름) — varchar(20)
  • email (이메일) — varchar(50)
  • password (비밀번호) — varchar(65)
  • created_at (생성일자) — localdatetime
  • updated_at (수정일자) — localdatetime