CONSUPPORT-hall

Tables (6)

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

Untitled

    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