Festibook
Tables (10)
Actual_response_table
- answ_no — int — Primary key — NOT NULL
- qust_no — int — Foreign key → Question_table.qust_no — NOT NULL
- festival_no — Long — Foreign key → Festival_table.festival_no — NOT NULL
- member_id — varchar(50) — Foreign key → Member_table.member_id — NOT NULL
- answ_cont — varchar(200) — NOT NULL
- answ_date — TIMESTAMP — NOT NULL
Community
- comm_no — int — Primary key — NOT NULL
- Member_id2 — varchar(50) — Foreign key → Member_table.member_id — NOT NULL
- comm_title — varchar(50)
- comm_content — varchar(500)
- comm_img — varchar(1000)
- comm_comment — varchar(200)
- comm_reg_date — date
- comm_mod_date — date
- comm_view — int — NOT NULL
Festival_table
- festival_no — int — Primary key — NOT NULL
- festival_category — varchar(50) — NOT NULL
- festival_name — varchar(50) — NOT NULL
- festival_contents — varchar(2000) — NOT NULL
- local — varchar(100 NOT NULL, `festival_addr` varchar(200) — NOT NULL
- festival_zipcode — varchar(200)
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- festival_phone — varchar(500)
- festival_homepage — varchar(500)
- festival_office — varchar(500)
- x — double — NOT NULL
- y — double — NOT NULL
- festival_image — varchar(2000)
- festival_view — int — NOT NULL
LostAndFound
- lost_no — INT — Primary key — NOT NULL
- Member_id — varchar(50) — Foreign key → Member_table.member_id — NOT NULL
- lost_title — VARCHAR(50) — NOT NULL
- lost_contents — VARCHAR(2000) — NOT NULL
- contents_img — VARCHAR(1000)
- comments — VARCHAR(100)
- lost_reg_date — DATE
- lost_mod_date — DATE
- lost_view — int — NOT NULL
MemberDetail_tbl
- detail_id — INT — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → Member_table.member_id — NOT NULL
- gender — enum
- age_group — varchar(10)
- category_name — varchar(100)
Member_table
- member_id — varchar(50) — Primary key — NOT NULL
- member_password — varchar(80) — NOT NULL
- member_email — varchar(100) — NOT NULL
- member_name — varchar(10) — NOT NULL
- member_nickname — varchar(80) — NOT NULL
- member_profile_image — BLOB
- member_introduce — varchar(200)
- member_sns — boolean
- verificationCode — varchar(10) — NOT NULL
- delflag — int — NOT NULL
Option_response_table
- opt_no — int — Primary key — NOT NULL
- qust_no — int — Foreign key → Question_table.qust_no — NOT NULL
- opt_cont — varchar(200) — NOT NULL
QnA
- qna_no — int — Primary key — NOT NULL
- Member_id — varchar(50) — Foreign key → Member_table.member_id — NOT NULL
- qna_title — varchar(100) — NOT NULL
- qna_content — varchar(500) — NOT NULL
- qna_regdate — date
- groupNo — int
- step — int
- sortNo — int
- qna_view — int — NOT NULL
Question_table
- qust_no — int — Primary key — NOT NULL
- qust_cont — varchar(200) — NOT NULL
- qust_type — varchar(10)
rating_table
- Rating_no — int — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → Member_table.member_id — NOT NULL
- festival_no — int — Foreign key → Festival_table.festival_no — NOT NULL
- rating_star — int — NOT NULL
- rating_content — varchar(500) — NOT NULL
- rating_date — TIMESTAMP — NOT NULL