outerpark

Tables (8)

Grades (Untitled6)

  • id (Key) — number — Primary key — NOT NULL
  • product_id (Key2) — number — Foreign key → Products.id — 공연id
  • name (Field) — varchar — 등급이름
  • price (Field2) — decimal — 등급가격

Hall (Untitled3)

  • id (Key) — number — Primary key — NOT NULL
  • name (Field) — varchar — 공연장이름
  • address (Field2) — varchar — 공연장위치

Members (Untitled)

  • id (Key) — number — Primary key — NOT NULL
  • email (Field) — varchar — 회원이메일
  • password (Field2) — varchar — 회원비밀번호
  • name (Field3) — varchar — 회원명
  • nickname (Field4) — varchar — 회원닉네임
  • phone (Field5) — number — -를 제외한 회원의 전화번호

Products (Untitled2)

  • id (Key) — number — Primary key — NOT NULL
  • hall_id (Key2) — number — Foreign key → Hall.id
  • name (Field) — varchar — 공연명
  • describe (Field3) — lob — 공연안내
  • running_time (Field2) — number — 공연시간

Round_Seats (Untitled9)

  • id (Key) — number — Primary key — NOT NULL
  • member_id (Key4) — number — Foreign key → Members.id — 예약자id
  • grade_id (Key5) — number — Foreign key → Grades.id — 좌석 등급id
  • round_id (Key2) — number — Foreign key → Rounds.id — 회차id
  • seat_id (Key3) — number — Foreign key → Seats.id — 좌석id
  • status (Field) — enum — 예약 상태
  • expire (Field2) — datetime — 락 만료시간

Rounds (Untitled4)

  • id (Key) — number — Primary key — NOT NULL
  • product_id (Key2) — number — Foreign key → Products.id — 공연id
  • date_time (Field) — datetime — 공연 시작 시각

Seats (Untitled7)

  • id (Key) — number — Primary key — NOT NULL
  • hall_id (Key2) — number — Foreign key → Hall.id — 공연장id
  • name (Field) — varchar — 좌석이름

Tickets (Untitled8)

  • id (Key) — number — Primary key — NOT NULL
  • member_id (Key4) — number — Foreign key → Members.id — 예약한 회원 id
  • round_seat_id (Key3) — number — Foreign key → Round_Seats.id — 회차 좌석id
  • product_name (Field) — varchar — 공연이름
  • hall_name (Field6) — varchar — 공연장 이름
  • round_date_time (Field3) — datetime — 공연 시작 시각
  • seat_name (Field5) — varchar — 좌석 이름
  • grade_name (Field2) — varchar — 등급 이름
  • price (Field4) — decimal — 티켓 가격