dnd -10th

Tables (4)

Folder (폴더)

  • id (아이디) — int — Primary key — NOT NULL
  • storage_id (저장소 아이디) — int — Foreign key → Storage.id — NOT NULL
  • name (폴더 명) — varchar(40)

Link (Untitled)

  • id (아이디) — int — Primary key — NOT NULL
  • storage_id (저장소 아이디) — int — Foreign key → Storage.id — NOT NULL
  • folder_id (폴더 아이디) — int — Foreign key → Folder.id — NOT NULL
  • thumbnail (썸네일) — varchar(200) — S3 url 을 저장한다.
  • name (링크명) — varchar(100)
  • created_at (생성날짜) — datetime
  • updated_at (수정날짜) — datetime
  • id (아이디2) — int — Foreign key → Member.id — NOT NULL

Member (사용자)

  • id (아이디) — int — Primary key — NOT NULL
  • nickname (닉네임) — varchar(15)
  • email (이메일) — varchar(30)
  • profile_image (프로필 사진) — varchar(200)
  • created_at (생성날짜) — datetime
  • updated_at (수정날짜) — datetime

Storage (저장소)

  • id (아이디) — int — Primary key — NOT NULL
  • member_id (사용자 아이디) — int — Foreign key → Member.id — NOT NULL
  • name (이름) — varchar(10)
  • email (이메일) — varchar(50)
  • color (색상) — varchar(10)
  • created_at (생성날짜) — datetime
  • updated_at (수정날짜) — datetime