TEST
Tables (13)
ADMIN
- ADMIN_ID — VARCHAR2(20 BYTE) — Primary key
- ADMIN_PWD — VARCHAR2(20 BYTE)
AUDIENCE
- AUDI_NO — NUMBER(4,0) — Primary key
- AUDI_DEB — NUMBER(4,0) — Foreign key → DEBATE.DEBATE_NO
- AUDI_MEM — NUMBER(4,0) — Foreign key → MEMBER.MEMBER_NO
- VOTE — NUMBER(4,0)
BOARD
- BOARD_NO — NUMBER(4,0) — Primary key
- BOARD_TYPE — VARCHAR2(20 BYTE)
- BOARD_TITLE — VARCHAR2(100 BYTE)
- BOARD_CONTENTS — VARCHAR2(1000 BYTE)
- BOARD_DATE — DATE
- BOARD_VIEWS — NUMBER(4,0)
- BOARD_MEM — NUMBER(4,0) — Foreign key → MEMBER.MEMBER_NO
BOARDCOMMENT
- COM_NO — NUMBER(4,0) — Primary key
- COM_DATE — DATE
- COM_CONTENTS — VARCHAR2(100 BYTE)
- COM_MEM — NUMBER(4,0) — Foreign key → MEMBER.MEMBER_NO
- COM_BOARD — NUMBER(4,0) — Foreign key → BOARD.BOARD_NO
BOARDLIKE
- BOARDLIKE_NO — NUMBER(4,0) — Primary key
- BOARDLIKE_MEM — NUMBER(4,0) — Foreign key → MEMBER.MEMBER_NO
- BOARDLIKE_BOARD — NUMBER(4,0) — Foreign key → BOARD.BOARD_NO
DEBATE
- DEBATE_NO — NUMBER(4,0) — Primary key
- DEBATE_WRITER — NUMBER(4,0) — Foreign key → MEMBER.MEMBER_NO
- DEBATE_TOPIC — VARCHAR2(100 BYTE)
- DEBATE_DATE — DATE
- DEBATE_TIME — NUMBER(4,0)
- DEBATE_STATUS — VARCHAR2(50 BYTE)
- DEBATE_STARTDATE — DATE
- DEBATE_ENDDATE — DATE
DEBATECOMMENT
- COM_NO — NUMBER(4,0) — Primary key
- COM_CONTENTS — VARCHAR2(100 BYTE)
- COM_DATE — DATE
- COM_DEB — NUMBER(4,0) — Foreign key → DEBATE.DEBATE_NO
- COM_MEM — NUMBER(4,0) — Foreign key → MEMBER.MEMBER_NO
DEBATEDETAIL
- DETAIL_NO — NUMBER(4,0) — Primary key
- DISCUSS — VARCHAR2(50 BYTE)
- EVI_ONE — VARCHAR2(1000 BYTE)
- EVI_TWO — VARCHAR2(1000 BYTE)
- EVI_THREE — VARCHAR2(1000 BYTE)
- IN_TIME — DATE
- DETAIL_DEB — NUMBER(4,0) — Foreign key → DEBATE.DEBATE_NO
- DISCUSSOR — NUMBER(4,0) — Foreign key → MEMBER.MEMBER_NO
DEBATELIKE
- DEBLIKE_NO — NUMBER(4,0) — Primary key
- DEBLIKE_DEB — NUMBER(4,0) — Foreign key → DEBATE.DEBATE_NO
- DEBLIKE_MEM — NUMBER(4,0) — Foreign key → MEMBER.MEMBER_NO
MEMBER
- MEMBER_NO — NUMBER(4,0) — Primary key
- MEMBER_SOCIAL_TYPE — VARCHAR2(20 BYTE)
- MEMBER_SOCIAL_NO — VARCHAR2(40 BYTE)
- MEMBER_NICKNAME — VARCHAR2(20 BYTE)
- MEMBER_GENDER — VARCHAR2(20 BYTE)
- MEMBER_EMAIL — VARCHAR2(30 BYTE)
- MEMBER_THUMB — VARCHAR2(100 BYTE)
- MEMBER_BIRTH — VARCHAR2(20 BYTE)
- MEMBER_ABLE — NUMBER(4,0)
NOTICE
- NOTICE_NO — NUMBER(4,0) — Primary key
- NOTICE_TYPE — VARCHAR2(20 BYTE)
- NOTICE_TITLE — VARCHAR2(100 BYTE)
- NOTICE_CONTENTS — VARCHAR2(1000 BYTE)
- NOTICE_DATE — DATE
- NOTICE_VIEWS — NUMBER(4,0)
- NOTICE_ADMIN — VARCHAR2(20 BYTE) — Foreign key → ADMIN.ADMIN_ID
NOTICECOMMENT
- COM_NO — NUMBER(4,0) — Primary key
- COM_NOTICE — NUMBER(4,0) — Foreign key → NOTICE.NOTICE_NO
- COM_DATE — DATE
- COM_CONTENTS — VARCHAR2(100 BYTE)
- COM_MEM — NUMBER(4,0) — Foreign key → MEMBER.MEMBER_NO
NOTICELIKE
- NOTICELIKE_NO — NUMBER(4,0) — Primary key
- NOTICELIKE_NOTICE — NUMBER(4,0) — Foreign key → NOTICE.NOTICE_NO
- NOTICELIKE_MEM — NUMBER(4,0) — Foreign key → MEMBER.MEMBER_NO