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 — 티켓 가격