현대이지웰

테이블 (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)