typeScript개인과제

테이블 (4)

Show (Untitled2)

  • id — integer(bigint) — 기본 키 — NOT NULL
  • name — varchar — NOT NULL
  • category — enum — NOT NULL
  • intro — text
  • photos — text
  • content — text — NOT NULL
  • actors — text — NOT NULL
  • price — integer — NOT NULL
  • firstShow — datetime — NOT NULL
  • lastShow — datetime — NOT NULL
  • theatre — NOT NULL

User (Untitled)

  • id — integer(bigint) — 기본 키
  • email — varchar — NOT NULL
  • password — varchar — NOT NULL
  • name — varchar — NOT NULL
  • nickname — varchar — NOT NULL
  • phone — varchar — NOT NULL
  • preference — enum
  • point — integer — NOT NULL

reservation (CopyOfUntitled3)

  • id — integer — 기본 키 — NOT NULL
  • id (id2) — integer(bigint) — 외래 키 → Show.id — NOT NULL
  • id (id3) — integer(bigint) — 외래 키 → User.id
  • user_name — varchar — NOT NULL
  • user_nickname — varchar — NOT NULL
  • show_name — varchar — NOT NULL
  • theatre — varchar — NOT NULL
  • seat — integer — NOT NULL
  • price — integer — NOT NULL
  • date — NOT NULL — 공연 날짜

theatre (Untitled3)

  • id — integer — 기본 키 — NOT NULL
  • id (id2) — integer(bigint) — 외래 키 → Show.id — NOT NULL
  • id (id3) — integer — 외래 키 → reservation.id — NOT NULL
  • name — varchar — NOT NULL
  • seats — integer — NOT NULL
  • seat_max — integer — NOT NULL