web_111

Tables (13)

Admin

  • admin_id — VARCHAR2(20) — Primary key — NOT NULL
  • admin_pwd — VARCHAR2(20)

Audience

  • debate_no — integer — Foreign key → dabate_main.debate_no — NOT NULL
  • member_no — integer — Foreign key → member.member_no — NOT NULL
  • vote — integer

Notice

  • notice_no — Integer — Primary key — NOT NULL
  • notice_title — varchar2(20)
  • notice_contents — varchar2(200)
  • notice_date — Date
  • notice_type — varchar2(20)
  • notice_views — Integer
  • admin_id — VARCHAR2(20) — NOT NULL

NoticeComment

  • notice_no — Integer — Primary key — NOT NULL
  • com_noticeOffi — Integer — Foreign key → Notice.notice_no — NOT NULL
  • com_date — date
  • com_contents — varchar2
  • com_member — integer — NOT NULL

NoticeLike

  • notice_no — Integer — Foreign key → Notice.notice_no — NOT NULL
  • member_no — integer — NOT NULL

board

  • board_no — integer — Primary key — NOT NULL
  • board_type — varchar2(20)
  • board_title — varchar2(100)
  • board_contents — varchar2(1000)
  • board_date — date
  • board_views — Integer
  • board_member — Integer — NOT NULL

board_comment

  • freeboard_no — integer — Foreign key → board.board_no — NOT NULL
  • com_no — integer — NOT NULL
  • freeboard_comment_date — date
  • freeboard_comment_dtl — varchar2
  • freeboard_member — integer — NOT NULL

board_like

  • freeboard_no — integer — Foreign key → board.board_no — NOT NULL
  • member_no — integer — NOT NULL

dabate_main

  • debate_no — integer — Primary key — NOT NULL
  • debate_writer — integer — NOT NULL
  • debate_topic — VARCHAR2(20)
  • debate_date — date
  • debate_time — integer
  • debate_status — varchar2
  • debate_startDate — date
  • debate_endDate — date

debate_comment

  • com_no — Integer — Primary key — NOT NULL
  • battle_no — integer — Foreign key → dabate_main.debate_no — NOT NULL
  • com_contents — varchar2
  • com_date — date
  • member_no — integer — NOT NULL

debate_detail

  • debate_no — integer — Foreign key → dabate_main.debate_no — NOT NULL
  • debate_discuss — varchar2
  • evi_one — varchar2
  • evi_two — varchar2
  • evi_three — varchar2
  • dabater — integer — NOT NULL
  • in_time — date

debate_like

  • debate_no — integer — Foreign key → dabate_main.debate_no — NOT NULL
  • member_no — integer — NOT NULL

member

  • member_no — integer — Primary key — NOT NULL
  • member_social_type — VARCHAR2(20)
  • member_social_no — VARCHAR2(30)
  • member_nickname — VARCHAR2(20)
  • member_gender — VARCHAR2(20)
  • member_email — VARCHAR2(20)
  • member_thumb — VARCHAR2(20)
  • member_birth — VARCHAR2(20)