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