퍼포미야_CONTROLLER

테이블 (3)

Controller

  • controller_id — varchar2(15) — 기본 키 — NOT NULL
  • controller_password — varchar(20) — NOT NULL

Join

  • user_id — varchar2(15) — 기본 키 — NOT NULL
  • controller_id — varchar2(15) — 외래 키 → Controller.controller_id — NOT NULL
  • user_name — varchar(10) — NOT NULL
  • user_nickname — varchar2(20) — NOT NULL
  • user_password — varchar(20) — NOT NULL

Musical

  • musical_Kortitle — varchar2(100) — 기본 키 — NOT NULL
  • controller_id — varchar2(15) — 외래 키 → Controller.controller_id — NOT NULL
  • musical_Entitle — varchar2(100)
  • musical_performer — varchar2(100) — NOT NULL
  • musical_age — int — NOT NULL
  • musical_story — varchar2(255) — NOT NULL
  • musical_place_url — varchar2(125)
  • musical_startDate — date — NOT NULL
  • musical_endDate — date — NOT NULL
  • musical_price — int — NOT NULL
  • musical_image — varchar2(100) — NOT NULL
  • musical_type — varchar2(2) — NOT NULL