Artique

Tables (3)

User (사용자)

  • Key — varchar(255) — Primary key — NOT NULL
  • nickname (Field) — varchar(255)
  • profile (Field2)
  • introduce (Field3)
  • password (Field4) — varchar(255)

musical (뮤지컬(연극))

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(255)
  • begin_date (Field2) — datetime(6)
  • end_date (Field6) — datetime(6)
  • place_name (Field3) — varchar(255)
  • genre (Field4) — varchar(255)
  • casting (Field5) — varchar(255)
  • running_time (Field7) — int
  • plot (Field8) — text
  • poster (Field9) — varchar(255)

review (리뷰)

  • id (Key) — bigint — Primary key — NOT NULL
  • star_rating (Field) — int
  • short_review (Field2) — text
  • long_review (Field3) — text
  • casting (Field4) — varchar(255)
  • view_date (Field5) — datetime(6)
  • seat (Field6) — varchar(255)
  • like (Field7) — bigint
  • Key (Key2) — varchar(255) — Foreign key → User.Key — NOT NULL
  • id (Key3) — bigint — Foreign key → musical.id — NOT NULL