qwerqewr

Tables (21)

ATTACHMENT

  • FID — NUMBER — Primary key — NOT NULL
  • ORIGINNAME — VARCHAR2(100)
  • CHANGENAME — VARCHAR2(100)
  • FILEPATH — VARCHAR2(3000)
  • UPLOADDATE — DATE
  • CAMP_CODE — NUMBER — NOT NULL
  • FCODE — NUMBER

BOARD_INDEX

  • B_NO — NUMBER — Primary key — NOT NULL
  • B_TITLE — VARCHAR2(100)
  • B_CONTENT — CLOB
  • UPDATE_DATE — DATE
  • B_TAG — NUMBER
  • B_COUNT — NUMBER
  • B_REGION — NUMBER
  • STATUS — VARCHAR2(1)
  • BOARD_WIRTER — NUMBER — NOT NULL
  • DISPO_ID — VARCHAR2(30)

CAMP_DETAIL

  • CD_NO — NUMBER — Primary key — NOT NULL
  • CAMP_CODE — NUMBER — Foreign key → CAMP_INFO.CAMP_CODE — NOT NULL
  • SITE_CODE — CHAR(4) — Foreign key → SITE_TYPE.SITE_CODE — NOT NULL
  • CD_SITE — VARCHAR2(100)
  • CD_PRICE — NUMBER
  • ADD_PRICE — NUMBER
  • DATE_MAX — NUMBER
  • STAY_MAX — NUMBER
  • RE_STATUS — CHAR(4)

CAMP_INFO

  • CAMP_CODE — NUMBER — Primary key — NOT NULL
  • CAMP_NAME — VARCHAR2(50)
  • CAMP_ADDRESS — VARCHAR2(100)
  • CAMP_PHONE — VARCHAR2(20)
  • CAMP_URL — VARCHAR2(50)
  • CAMP_THEME — NUMBER
  • AVAILABLE_DATE — DATE
  • POSTING_YN — CHAR(1)
  • REFUNDMENT — VARCHAR2(1000)
  • CAMP_ETC — VARCHAR2(1000)
  • OPERATOR_NAME — VARCHAR(30)
  • OPERATOR_NO — VARCHAR2(20)
  • PERMIIT_YN — CHAR(1)
  • CAMP_OPTION — VARCHAR2(1000)
  • USER_NO — NUMBER — NOT NULL

COMMENT_INDEX

  • C_NO — NUMBER — Primary key — NOT NULL
  • C_CONTENT — VARCHAR2(1000)
  • UPDATE_DATE — DATE
  • STATUS — VARCHAR2(1)
  • REVIEW_SCORE — NUMBER
  • DISPO_ID — VARCHAR2(30) — NOT NULL
  • COMMENT_WRITER — NUMBER — NOT NULL
  • CAMP_CODE — NUMBER — NOT NULL

COUPON_LIST

  • C_CODE — VARCHAR2(100) — Primary key — NOT NULL
  • C_NAME — VARCHAR2(100)
  • C_DISCOUNT — NUMBER
  • C_GRADE — VARCHAR2(1)
  • C_STARTDAY — DATE
  • C_ENDDAY — DATE
  • C_STATUS — CHAR(1)

IPINFO

  • INFO_NO — NUMBER — Primary key — NOT NULL
  • USER_NO — NUMBER — NOT NULL
  • CONNECT_DATE — VARCHAR2(50)
  • IP — VARCHAR2(50)
  • CONNECT_COUNTRY — VARCHAR2(50)
  • SOF — VARCHAR2(50)

JOINCODE

  • USER_ID — varchar2(50) — Primary key — NOT NULL
  • R_CODE — varchar2(100)

MEMBER

  • USER_NO — NUMBER — Primary key — NOT NULL
  • USER_TYPE — VARCHAR2(30)
  • USER_ID — VARCHAR2(30)
  • USER_NAME — VARCHAR2(15)
  • USER_PWD — VARCHAR2(100)
  • PHONE — VARCHAR2(13)
  • EMAIL — VARCHAR2(100)
  • BIRTHDATE — VARCHAR2(30)
  • GENDER — VARCHAR2(3)
  • FORIGNYN — VARCHAR2(30)
  • STATUS — VARCHAR2(10)
  • GRADE — CHAR(1)
  • JOIN_DATE — VARCHAR2(30)

MEMO

  • MEMO_NO — NUMBER — Primary key — NOT NULL
  • CONTENT — VARCHAR2(300)
  • USER_NO — NUMBER — NOT NULL

OPTION_INFO

  • OP_NO — NUMBER — Primary key — NOT NULL
  • CAMP_CODE — NUMBER — Foreign key → CAMP_INFO.CAMP_CODE — NOT NULL
  • OP_CODE — CHAR(4) — Foreign key → OPTION_TYPE.OP_CODE — NOT NULL
  • OP_NAME — VARCHAR2(20)
  • OP_PRICE — NUMBER
  • OP1_MAX — NUMBER
  • OP2_MAX — NUMBER

OPTION_TYPE

  • OP_CODE — CHAR(4) — Primary key — NOT NULL
  • OP_NAME — VARCHAR2(50)

QES_INDEX

  • Q_NO — NUMBER — Primary key — NOT NULL
  • Q_TITLE — VARCHAR2(100)
  • Q_CONTENT — CLOB
  • UPDATE_DATE — DATE
  • Q_TAG — NUMBER
  • ANS_YN — VARCHAR2(1)
  • ANS — VARCHAR2(4000)
  • DISPO_ID — VARCHAR2(30) — NOT NULL
  • ANS_WRITER — NUMBER — NOT NULL
  • FREQ — VARCHAR2(1)

RESERVATION

  • RE_NO — NUMBER — Primary key — NOT NULL
  • RP_NO — NUMBER — Foreign key → RESERVATION_PERSON.RP_NO — NOT NULL
  • CAMP_CODE — NUMBER — NOT NULL
  • RE_SITE — CHAR(10) — NOT NULL

RESERVATION_ADMIN

  • RE_NO — NUMBER — Primary key — NOT NULL
  • RP_NO — NUMBER — Foreign key → RESERVATION_PERSON.RP_NO — NOT NULL
  • PAYMENT_DATE — DATE
  • RE_DATE — VARCHAR2(50)
  • RE_COST — NUMBER
  • RE_STATUS — NUMBER
  • PAYMENT_TYPE — VARCHAR2(20)
  • USER_NO — NUMBER — NOT NULL
  • CAMP_CODE — NUMBER — NOT NULL

RESERVATION_PERSON

  • RP_NO — NUMBER — Primary key — NOT NULL
  • RP_NAME — VARCHAR2(10)
  • RP_PWD — VARCHAR2(20)
  • RP_PHONE — VARCHAR2(20)
  • RP_CAR — VARCHAR2(20)
  • RP_MESSAGE — VARCHAR2(1000)
  • RP_PAYMENT — NUMBER
  • RP_DATE — DATE
  • ENT_DATE — DATE
  • PAYMENT_TYPE — VARCHAR2(20)
  • PAYMENT_STATUS — CHAR(2)
  • RP_GRADE — CHAR(2)
  • RP_CAMPNAME — VARCHAR2(50)

REVIEW

  • RE_NO — NUMBER — Foreign key → RESERVATION_ADMIN.RE_NO — NOT NULL
  • USER_NO — NUMBER
  • USER_ID — VARCHAR2(50)
  • CAMP_CODE — NUMBER
  • CAMP_NAME — VARCHAR2(100)
  • RE_DATE — VARCHAR2(100)
  • R_TITLE — VARCHAR2(100)
  • R_CONTENT — VARCHAR2(100)
  • R_NUM — NUMBER

SITE_TYPE

  • SITE_CODE — CHAR(4) — Primary key — NOT NULL
  • SITE_NAME — VARCHAR2(20)

USERFAVORITE

  • USER_NO — NUMBER — Foreign key → MEMBER.USER_NO — NOT NULL
  • CAMP_CODE — NUMBER — Foreign key → CAMP_INFO.CAMP_CODE — NOT NULL

USERPROPIC

  • USER_NO — NUMBER — Foreign key → MEMBER.USER_NO — NOT NULL
  • O_NAME — VARCHAR2(50)
  • C_NAME — VARCHAR2(50)

USER_COUPON_LIST

  • USER_NO — NUMBER — Foreign key → MEMBER.USER_NO — NOT NULL
  • C_CODE — VARCHAR2(100) — Foreign key → COUPON_LIST.C_CODE — NOT NULL
  • U_STATUS — CHAR(1)