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