퍼포미야_USER

테이블 (5)

Join

  • user_id — varchar2(15) — 기본 키 — 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
  • user_id — varchar2(15) — 외래 키 → Join.user_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

Poster

  • poster_title — varchar2(100) — 기본 키 — NOT NULL
  • poster_image — varchar2(100) — NOT NULL
  • poster_explain — varchar2(255) — NOT NULL

Reserve

  • reserve_pin — varchar2(20) — 기본 키 — NOT NULL
  • user_id — varchar2(15) — 외래 키 → Join.user_id — NOT NULL
  • reserve_title — varchar2(100) — NOT NULL
  • reserve_seat — varchar2(20) — NOT NULL
  • reserve_date — date — NOT NULL
  • reserve_time — time — NOT NULL
  • reserve_price — int — NOT NULL

Review

  • review_title — varchar2(100) — 기본 키 — NOT NULL
  • user_id — varchar2(15) — 외래 키 → Join.user_id — NOT NULL
  • user_nickname — varchar2(20) — NOT NULL
  • review_context — varchar2(255) — NOT NULL
  • review_date — date — NOT NULL
  • review_star — varchar2(5) — NOT NULL
  • review_count — int — NOT NULL
  • review_number — int — NOT NULL