CONSUPPORT-tiket
Tables (8)
CONCERT
- CONCERT_CODE (concertCode) — VARCHAR2(100) — Primary key — NOT NULL
- USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
- HALL_CODE (hallCode) — VARCHAR2(100) — Foreign key → HALL.HALL_CODE — NOT NULL
- CONCERT_NAME (concertName) — VARCHAR2(100) — NOT NULL
- CONCERT_STATUS (concertStatus) — VARCHAR2(20) — NOT NULL
- CONCERT_RATED (concertRated) — VARCHAR2(20) — NOT NULL
- CONCERT_TICKETING_DATE (concertTicketingDate) — DATE — NOT NULL
COUPON
- COUPON_CODE (couponCode) — VARCHAR2(100) — Primary key — NOT NULL
- USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
- SALES_CODE (salesCode) — VARCHAR2(100) — Foreign key → SALES.SALES_CODE — NOT NULL
- COUPON_VALUE (couponValue) — NUMBER — NOT NULL
- COUPON_STATUS (couponStatus) — VARCHAR2(20) — NOT NULL
HALL
- HALL_CODE (hallCode) — VARCHAR2(100) — Primary key — NOT NULL
- USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
- HALL_NAME (hallName) — VARCHAR2(100) — NOT NULL
- HALL_SEAT_CNT (hallSeatCnt) — NUMBER — NOT NULL
- HALL_RENT_PRICE (hallRentPrice) — NUMBER — NOT NULL
- HALL_DETAIL (hallDetail) — VARCHAR2(500)
SALES
- SALES_CODE (salesCode) — VARCHAR2(100) — Primary key — NOT NULL
- USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
- HALL_CODE (hallCode) — VARCHAR2(100) — Foreign key → HALL.HALL_CODE — NOT NULL
- CONCERT_CODE (concertCode) — VARCHAR2(100) — Foreign key → CONCERT.CONCERT_CODE — NOT NULL
- SALES_AMOUNT (salesAmount) — NUMBER — NOT NULL
- SALES_TOTAL_PRICE (salesTotalPrice) — NUMBER — NOT NULL
- SALES_DATE (salesDate) — DATE — NOT NULL
- SALES_STATUS (salesStatus) — VARCHAR2(20) — NOT NULL
SALES_DETAIL (Untitled)
- SALES_DETAIL_CODE (salesDetailCode) — VARCHAR2(100) — Primary key — NOT NULL
- SALES_CODE (salesCode) — VARCHAR2(100) — Foreign key → SALES.SALES_CODE — NOT NULL
- TICKET_CODE (ticketCode) — VARCHAR2(100) — Foreign key → TICKET.TICKET_CODE — NOT NULL
TICKET
- TICKET_CODE (ticketCode) — VARCHAR2(100) — Primary key — NOT NULL
- USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
- HALL_CODE (hallCode) — VARCHAR2(100) — Foreign key → HALL.HALL_CODE — NOT NULL
- CONCERT_CODE (concertCode) — VARCHAR2(100) — Foreign key → CONCERT.CONCERT_CODE — NOT NULL
- SEAT_CODE (seatCode) — VARCHAR2(100) — NOT NULL
User
- USER_ID (userId) — VARCHAR2(100) — Primary key — NOT NULL
- USER_PW (userPw) — VARCHAR2(100) — NOT NULL
- USER_NAME (userName) — VARCHAR2(100) — NOT NULL
- USER_ADDR (userAddr) — VARCHAR2(100) — NOT NULL
- USER_ADDR_DETAIL (userAddrDetail) — VARCHAR2(100)
- USER_BIRTH (userBirth) — VARCHAR2(100) — NOT NULL
- USER_TELL (userTell) — VARCHAR2(100) — NOT NULL
- USER_ROLE (userRole) — VARCHAR2(20) — NOT NULL
- USER_STATUS (userStatus) — VARCHAR2(20) — NOT NULL