CONSUPPORT

Tables (18)

ABOARD

  • USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
  • QBOARD_NUM (qboardNum) — NUMBER — Foreign key → QBOARD.QBOARD_NUM — NOT NULL
  • ANSWER (answer) — VARCHAR2(100) — NOT NULL
  • ANSWER_DATE (answerDate) — DATE

ARTIST

  • USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
  • ARTIST_NAME (artistName) — VARCHAR2(100) — NOT NULL
  • ARTIST_DETAIL (artistDetail) — VARCHAR2(100) — NOT NULL

ARTIST_IMG

  • ARTIST_IMG_CODE (artistImgCode) — VARCHAR2(100) — Primary key — NOT NULL
  • USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
  • ARTIST_IMG_NAME_ORIGIN (artistImgNameOrigin) — VARCHAR2(100) — NOT NULL
  • ARTIST_IMG_NAME_ATTACHED (artistImgNameAttached) — VARCHAR2(100) — NOT NULL
  • ARTIST_IMG_IS_MAIN (artistImgIsMain) — VARCHAR2(20) — NOT NULL

CONCERT

  • CONCERT_CODE (concertCode) — VARCHAR2(100) — Primary key — NOT NULL
  • USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
  • GENRE_CODE (genreCode) — VARCHAR2(100) — Foreign key → GENRE.GENRE_CODE — NOT NULL
  • HALL_CODE (hallCode) — VARCHAR2(100) — Foreign key → HALL.HALL_CODE — NOT NULL
  • HALL_DATE_CODE (hallDateCode) — VARCHAR2(100) — Foreign key → HALL_DATE.HALL_DATE_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

CONCERT_IMG

  • CONCERT_IMG_CODE (concertImgCode) — VARCHAR2(100) — Primary key — NOT NULL
  • CONCERT_CODE (concertCode) — VARCHAR2(100) — Foreign key → CONCERT.CONCERT_CODE — NOT NULL
  • Key — Foreign key — NOT NULL
  • CONCERT_IMG_NAME_ORIGIN (concertImgNameOrigin) — VARCHAR2(100) — NOT NULL
  • CONCERT_IMG_NAME_ATTACHED (concertImgNameAttached) — VARCHAR2(100) — NOT NULL
  • CONCERT_IMG_IS_MAIN (concertImgIsMain) — VARCHAR2(20) — NOT NULL

CONCERT_PRICE

  • CONCERT_CODE (concertCode) — VARCHAR2(100) — Foreign key → CONCERT.CONCERT_CODE — NOT NULL
  • Key — Foreign key — NOT NULL
  • CONCERT_PRICE_R (concertPriceR) — NUMBER
  • CONCERT_PRICE_S (concertPriceS) — NUMBER
  • CONCERT_PRICE_A (concertPriceA) — NUMBER

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

GENRE

  • GENRE_CODE (genreCode) — VARCHAR2(100) — Primary key — NOT NULL
  • GENRE_NAME (genreName) — VARCHAR2(100) — 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)

HALL_DATE

  • HALL_DATE_CODE (hallDateCode) — VARCHAR2(100) — Primary key — NOT NULL
  • HALL_CODE (hallCode) — VARCHAR2(100) — Foreign key → HALL.HALL_CODE — NOT NULL
  • HALL_RENT_DATE (hallRentDate) — DATE — NOT NULL
  • HALL_STATUS (hallStatus) — VARCHAR2(20) — NOT NULL

HALL_IMG

  • HALL_DATE_CODE (hallDateCode) — VARCHAR2(100) — Primary key — NOT NULL
  • HALL_CODE (hallCode) — VARCHAR2(100) — Foreign key → HALL.HALL_CODE — NOT NULL
  • HALL_IMG_NAME_ORIGIN (hallImgNameOrigin) — VARCHAR2(100) — NOT NULL
  • HALL_IMG_NAME_ATTACHED (hallImgNameAttached) — VARCHAR2(100) — NOT NULL
  • HALL_IMG_IS_MAIN (hallImgIsMain) — VARCHAR2(20) — NOT NULL

HALL_SEAT

  • HALL_CODE (hallCode) — VARCHAR2(100) — Foreign key → HALL.HALL_CODE — NOT NULL
  • HALL_SEAT_R_CNT (hallSeatRCnt) — NUMBER
  • HALL_SEAT_S_CNT (hallSeatSCnt) — NUMBER
  • HALL_SEAT_A_CNT (hallSeatACnt) — NUMBER

QBOARD

  • QBOARD_NUM (qboardNum) — NUMBER — Primary key — NOT NULL
  • USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
  • QBOARD_TITLE (qboardTitle) — VARCHAR2(100) — NOT NULL
  • QBOARD_CONTENT (qboardContent) — VARCHAR2(100) — NOT NULL
  • QBOARD_CREATE_DATE (qboardCreateDate) — DATE
  • Q_SECRET (qsecret) — VARCHAR2(50)

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
  • Key — Foreign key — NOT NULL

SPECIAL_CONCERT

  • CONCERT_CODE (concertCode) — VARCHAR2(100) — Foreign key → CONCERT.CONCERT_CODE — NOT NULL
  • Key — Foreign key — NOT NULL
  • REG_DATE (regDate) — DATE — 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