현대이지웰
테이블 (11)
MULTI24_ACTOR (Untitled4)
- ACTOR_NO (Key) — NUMBER — 기본 키 — NOT NULL
- FILE_NO (Key2) — VARCHAR2(255) — 외래 키 → MULTI24_SHOWACTOR_FILE.FILE_NO — NOT NULL
- ACTOR_NAME (Field) — VARCHAR2(30)
- ACTOR_INFO (Field2) — VARCHAR2(4000)
- actorEdu (Field3) — VARCHAR2(50)
- actorBirth (Field4) — DATE
- actorDebut (Field5) — DATE
- actorNation (Field6) — VARCHAR2(70)
MULTI24_INQUIRY (Untitled5)
- INQUIRY_NO (Key) — NUMBER — 기본 키 — NOT NULL
- MEMBER_NO (Key2) — NUMBER — 외래 키 → MULTI24_MEMBER.MEMBER_NO — NOT NULL
- INQUIRY_FILE_NO (Key3) — VARCHAR2(255) — 외래 키 → MULTI24_INQUIRY_FILE.INQUIRY_FILE_NO — NOT NULL
- INQUIRY_DATE (Field) — DATE
- INQUIRY_TITLE (Field2) — VARCHAR2(105)
- INQUIRY_CONTENT (Field3) — VARCHAR2(900)
- INQUIRY_STATUS (Field4) — InquiryStatus
- INQUIRY_ANSWER (Field5) — VARCHAR2(1500)
- INQUIRY_ANSWERDATE (Field6) — DATE
MULTI24_INQUIRY_FILE (Untitled6)
- INQUIRY_FILE_NO (Key) — VARCHAR2(255) — 기본 키 — NOT NULL
- INQUIRY_NO (Key2) — NUMBER — 외래 키 → MULTI24_INQUIRY.INQUIRY_NO — NOT NULL
- INQUIRY_FILE_NAME (Field) — VARCHAR2(255)
- INQUIRY_STORE_FILE_NAME (Field2) — VARCHAR2(255)
- INQUIRY_FILE_PATH (Field3) — VARCHAR2(255)
- INQUIRY_FILE_DATE (Field4) — DATE
MULTI24_LIKEYO (Untitled7)
- LIKE_NO (Key) — NUMBER — 기본 키 — NOT NULL
- MEMBER_NO (Key4) — NUMBER — 외래 키 → MULTI24_MEMBER.MEMBER_NO — NOT NULL
- ACTOR_NO (Key3) — NUMBER — 외래 키 → MULTI24_ACTOR.ACTOR_NO — NOT NULL
- SHOW_NO (Key2) — NUMBER — 외래 키 → MULTI24_SHOW.SHOW_NO — NOT NULL
- STATUS (Field) — VARCHAR2(2)
MULTI24_MEMBER (Untitled)
- MEMBER_NO (Key) — NUMBER — 기본 키 — NOT NULL
- MEMBER_ID (Field) — VARCHAR2(500)
- MEMBER_PW (Field2) — VARCHAR2(500)
- MEMBER_NAME (Field3) — VARCHAR2(500)
- MEMBER_PHONE (Field4) — VARCHAR2(500)
- MEMBER_ADDR (Field5) — VARCHAR2(500)
- MEMBER_ADDRDE (Field6) — VARCHAR2(500)
- MEMBER_STATUS (Field7) — VARCHAR2(500)
- MEMBER_DATE (Field8) — DATE
MULTI24_PAYMENT (Untitled9)
- payment_id (Key) — VARCHAR2(255) — 기본 키 — NOT NULL
- MEMBER_NO (Key2) — NUMBER — 외래 키 → MULTI24_MEMBER.MEMBER_NO — NOT NULL
- SHOW_DATE (Key32) — DATE — 외래 키 → MULTI24_SEAT.SHOW_DATE — NOT NULL
- payment_type (Field) — VARCHAR2(255)
- payment_amount (Field2) — NUMBER
- payment_order_name (Field3) — VARCHAR2(255)
- payment_order_id (Field4) — VARCHAR2(255)
- payment_paysuccess_yn (Field5) — NUMBER
- payment_key (Field6) — VARCHAR2(255)
- show_time (Field8) — DATE
- seat_spaces (Field9) — VARCHAR2(255)
- member_name (Field10) — VARCHAR2(255)
MULTI24_REVIEW (Untitled10)
- REVIEW_NO (Key) — NUMBER — 기본 키 — NOT NULL
- MEMBER_NO (Key2) — NUMBER — 외래 키 → MULTI24_MEMBER.MEMBER_NO — NOT NULL
- SHOW_NO (Key3) — NUMBER — 외래 키 → MULTI24_SHOW.SHOW_NO — NOT NULL
- REVIEW_TITLE (Field) — VARCHAR(100)
- REVIEW_CONTENT (Field2) — VARCHAR(1000)
- REVIEW_DATE (Field3) — DATE
- REVIEW_SCORE (Field4) — NUMBER
MULTI24_SEAT (Untitled11)
- SEAT_NO (Key) — NUMBER — 기본 키 — NOT NULL
- SHOW_DATE (Key3) — DATE — 기본 키 — NOT NULL
- SHOW_NO (Key2) — NUMBER — 외래 키 → MULTI24_SHOW.SHOW_NO — NOT NULL
- SEAT_SPACE (Field) — VARCHAR2(10)
- IS_BOOK (Field2) — VARCHAR2(2)
- TOT_SEAT (Field3) — INT
- LEFT_SEAT (Field4) — INT
- SHOW_TIME (Field5) — DATE
MULTI24_SHOW (Untitled8)
- SHOW_NO (Key) — NUMBER — 기본 키 — NOT NULL
- FILE_NO (Key2) — VARCHAR2(255) — 외래 키 → MULTI24_SHOWACTOR_FILE.FILE_NO — NOT NULL
- SHOW_PRICE (Field) — VARCHAR2(20)
- START_DATE (Field2) — DATE
- END_DATE (Field3) — DATE
- SHOW_TITLE (Field4) — VARCHAR2(1000)
- SHOW_INFO (Field5) — VARCHAR2(4000)
- SHOW_CATE (Field6) — VARCHAR2(30)
- SHOW_START_TIME (Field7) — VARCHAR(20)
- SHOW_PLAYTIME (Field8) — INTEGER
- SHOW_RATING (Field9) — VARCHAR(20)
- OPEN_DATE (Field10) — DATE
- Likes (Field11) — NUMBER
MULTI24_SHOWACTOR_FILE (Untitled2)
- FILE_NO (Key) — VARCHAR2(255) — 기본 키 — NOT NULL
- SHOW_NO (Key3) — NUMBER — 외래 키 → MULTI24_SHOW.SHOW_NO — NOT NULL
- ACTOR_NO (Key2) — NUMBER — 외래 키 → MULTI24_ACTOR.ACTOR_NO — NOT NULL
- FILE_PATH (Field) — VARCHAR2(255)
- FILE_NAME (Field2) — VARCHAR2(255)
- FILE_DATE (Field3) — DATE
MULTI24_SHOW_ACTOR (Untitled12)
- SHOW_ACTOR (Key) — NUMBER — 기본 키 — NOT NULL
- SHOW_NO (Key3) — NUMBER — 외래 키 → MULTI24_SHOW.SHOW_NO — NOT NULL
- ACTOR_NO (Key2) — NUMBER — 외래 키 → MULTI24_ACTOR.ACTOR_NO — NOT NULL
- ROLE_NAME (Field) — VARCHAR2(100)