youtude_drawer

유뷰브 서랍 테이블 ERD

테이블 (4)

book (Untitled3)

  • id (Key) — varchar(50) — 기본 키 — NOT NULL
  • category_id (Key2) — varchar(50) — 외래 키 → category.id — NOT NULL
  • name (Field) — varchar(225)
  • youtube_url (Field2) — varchar(225)
  • memo (Field3) — varchar(225)
  • date_created (Field4) — datetime
  • last_updated (Field5) — datetime

category (Untitled2)

  • id (Key) — varchar(50) — 기본 키 — NOT NULL
  • user_id (varchar(50)) — varchar(50) — 외래 키 → user.id — NOT NULL
  • name (Field) — varchar(225)
  • date_created (Field2) — datetime
  • last_updated (Field3) — datetime

oauth (Untitled)

  • id (Key) — varchar(50) — 기본 키 — NOT NULL
  • user_id (varchar(50)) — varchar(50) — 외래 키 → user.id — NOT NULL
  • version (Field2) — bigint(20)
  • access_token (Field3) — varchar(225)
  • provider (Field5) — varchar(225)

user

  • id (varchar(50)) — varchar(50) — 기본 키 — NOT NULL
  • password — varchar(50)
  • nickname — varchar(50)
  • email — varchar(50)
  • version (Field2) — bigint(20)
  • create_id (deletedAt) — varchar(225)
  • date_created (createdAt) — datetime
  • update_id (Field) — varchar(225)
  • last_updated (updatedAt) — datetime