ConcertReserv
테이블 (7)
결제 (PAYMENT)
- PAYMENT_ID (Key) — BINARY(16) — 기본 키 — NOT NULL
- PAY_YN (Field) — VARCHAR
- PRICE (Field2) — LONG
- ACTU_AMOUNT (Field3) — LONG
- DUE_TIME (Field4) — TIMESTAMP
- CREATE_DT (Field5) — TIMESTAMP
- UPDATE_DT (Field6) — TIMESTAMP
- RESERVATION_ID (Key2) — BINARY(16) — 외래 키 → 예약.RESERVATION_ID — NOT NULL
- TOKEN_ID (Field7) — LONG
대기열토큰 (TOKEN)
- TOKEN_ID (PK) — BINARY(16) — 기본 키 — NOT NULL
- WAIT_ORDER (Field3) — LONG
- STATUS (Field) — LONG — 0 = AVAILABLE 1 = WAIT 2 = EXPIRED
- CREATE_DT (Field4) — TIMESTAMP
- UPDATE_DT (Field5) — TIMESTAMP
- CONCERT_ID (Field2) — BIANRY(16)
- MEMBER_ID (Field6) — BINARY(16)
사용자 (MEMBER)
- MEMBER_ID (Key) — BINARY(16) — 기본 키 — NOT NULL
- MEMBER_NM (Field) — VARCHAR
- POINT (Field2) — LONG
- CREATE_DT (Field3) — TIMESTAMP
- UPDATE_DT (Field4) — TIMESTAMP
예약 (RESERVATION)
- RESERVATION_ID (Key) — BINARY(16) — 기본 키 — NOT NULL
- CONFIRM_YN (Field) — VARCHAR
- CREATE_DT (Field5) — TIMESTAMP
- UPDATE_DT (Field3) — TIMESTAMP
- MEMBER_ID (Key2) — BINARY(16) — 외래 키 → 사용자.MEMBER_ID — NOT NULL
- SEAT_ID (Field4) — BINARY(16) — 외래 키 → 좌석.SEAT_ID — NOT NULL
좌석 (SEAT)
- SEAT_ID (Key) — BINARY(16) — 기본 키 — NOT NULL
- SEAT_NO (Field2) — VARCHAR
- SEAT_CLASS (Field3) — VARCHAR
- PRICE (Field4) — LONG
- CREATE_DT (Field6) — TIMESTAMP
- UPDATE_DT (Field7) — TIMESTAMP
- CONCERT_DATE (UNIQUE KEY1) — TIMESTAMP — 외래 키 → 콘서트 스케줄.CONCERT_DATE — NOT NULL
- CONCERT_ID (UNIQUE_KEY2) — BINARY(16) — 외래 키 → 콘서트 스케줄.CONCERT_ID — NOT NULL
- STATUS (Key3) — VARCHAR
콘서트 (CONCERT)
- CONCERT_ID (Key) — BINARY(16) — 기본 키 — NOT NULL
- PERFORMER (Field1) — VARCHAR
- CONCERT_NM (Field2) — VARCHAR
- CREATE_DT (Field3) — TIMESTAMP
- UPDATE_DT (Field4) — TIMESTAMP
콘서트 스케줄 (CONCERT_SCHEDULE)
- CONCERT_DATE (Key2) — TIMESTAMP — 기본 키 — NOT NULL
- CONCERT_ID (Key) — BINARY(16) — 외래 키 → 콘서트.CONCERT_ID — NOT NULL
- DEL_YN (Field) — VARCHAR
- HALL_NM (Field3) — VARCHAR
- CREATE_DT (Field4) — TIMESTAMP
- UPDATE_DT (Field5) — TIMESTAMP