12312
Tables (12)
HOST_DETAIL
- USERID — VARCHAR2(50)
- HOST_INTRO — VARCHAR2(4000)
- BANK_NAME — VARCHAR2(50)
- ACCOUNT_NUM — VARCHAR2(50)
- APPROVAL_YN — CHAR(1)
TB_BOARD
- BOARD_IDX — NUMBER
- USERID — VARCHAR2(50)
- SUBJECT — VARCHAR2(300)
- CONTENT — CLOB
- GROUPNUM — NUMBER
- DEPTH — NUMBER
- ORDERNO — NUMBER
- PARENT — NUMBER
- HITCOUNT — NUMBER
- DEL_YN — CHAR(1)
- REG_DATE — DATE
TB_MESSAGE
- MSG_IDX — NUMBER
- SENDER_ID — VARCHAR2(50)
- RECEIVER_ID — VARCHAR2(50)
- CONTENT — VARCHAR2(1000)
- READ_YN — CHAR(1)
- SEND_DATE — DATE
TB_REPLY
- REPLY_IDX — NUMBER
- BOARD_IDX — NUMBER
- USERID — VARCHAR2(50)
- CONTENT — VARCHAR2(4000)
- PARENT_IDX — NUMBER
- DEL_YN — CHAR(1)
- BLOCK_YN — CHAR(1)
- REG_DATE — DATE
TB_REPLY_LIKE
- REPLY_IDX — NUMBER
- USERID — VARCHAR2(50)
- LIKE_TYPE — NUMBER
- REG_DATE — DATE
TB_REVIEW
- REV_IDX — NUMBER
- RES_IDX — NUMBER
- RATING — NUMBER
- CONTENT — VARCHAR2(1000)
- REG_DATE — DATE
TB_SCH
- SCH_IDX — NUMBER
- CLASS_IDX — NUMBER
- CLASS_DATE — DATE
- START_TIME — VARCHAR2(5)
- END_TIME — VARCHAR2(5)
- MAX_PEOPLE — NUMBER
- CUR_PEOPLE — NUMBER
classList
- classIdx — NUMBER
- memberIdx — NUMBER — NOT NULL
- status — NUMBER(1) — 1: 게시중, 2: 모집 완료, 3: 숨김, 4: 삭제
- title — VARCHAR2(300)
- content — CLOB
- category — VARCHAR2(50)
- capacity — NUMBER
- classDate — DATE
- classTime — VARCHAR(255)
- place — VARCHAR(255)
- price — NUMBER
- hitCount — NUMBER
- regDate — DATE
member1
- memberIdx — NUMBER — Primary key — NOT NULL
- userId — VARCHAR2(50)
- userPwd — VARCHAR2(100)
- userName — VARCHAR2(50)
- userLevel — NUMBER(3) — 1:guest, 50: host, 99: admin
- enabled — NUMBER(1) — 1: active, 2: deleted
- regDate — DATE — YYYY-MM-DD
- modiDate — DATE
member2
- memberIdx — NUMBER — Foreign key → member1.memberIdx — NOT NULL
- email — VARCHAR2(50)
- birth — DATE — YYYY-MM-DD
- profilePhoto — VARCHAR2(500)
- tel — VARCHAR2(20)
- zip — VARCHAR(7)
- addr1 — VARCHAR2(100)
- addr2 — VARCHAR2(100)
reservation
- memberIdx — NUMBER — Foreign key → member1.memberIdx — NOT NULL
- classIdx — NUMBER — Foreign key → classList.classIdx
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
wish
- memberIdx — NUMBER — Foreign key → member1.memberIdx — NOT NULL
- classIdx — NUMBER — Foreign key → classList.classIdx