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)