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)