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