project
Tables (18)
alarm
- alarm_id — int(10) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- alarm_content — varchar(200) — NOT NULL
- alarm_date — date — NOT NULL
- alarm_read — int(1) — NOT NULL
- hide — int(1) — NOT NULL
apply
- apply_id — int(10) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- board_id — int(5) — NOT NULL
- subject — varchar(100)
- apply_date — date — NOT NULL
- status — varchar(10) — NOT NULL
- investment — varchar(10)
blind_board
- blind_id — int(10) — Primary key — NOT NULL
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- board_id — int(5) — NOT NULL
- subject — varchar(150) — NOT NULL
- write_date — date — NOT NULL
- cancel — int(1) — NOT NULL
block
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- block_member — varchar(50) — NOT NULL
category
- category_id — varchar(20) — Primary key — NOT NULL
common_column
- board_id — int(5) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- hit — int(10) — NOT NULL
- write_date — date — NOT NULL
- subject — varchar(100) — NOT NULL
- content — varchar(1000) — NOT NULL
- recruit_time — datetime — NOT NULL
- appoint_time — datetime — NOT NULL
- appoint_place — varchar(200) — NOT NULL
- gender — varchar(20) — NOT NULL
- member_cnt — int(1) — NOT NULL
- recruit_end — int(1) — NOT NULL
- hide — int(1) — NOT NULL
delivery_board
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- board_id — int(5) — Foreign key → common_column.board_id — NOT NULL
- min_delivery — varchar(10) — NOT NULL
- delivery_fee — varchar(10) — NOT NULL
- super_fund — varchar(10) — NOT NULL
- min_fund — varchar(10) — NOT NULL
history
- history_id — int(10) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- board_id — int(5) — NOT NULL
- subject — varchar(150) — NOT NULL
- history_date — date — NOT NULL
- hide — int(1) — NOT NULL
inquery
- inquery_id — int(5) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- subject — varchar(150) — NOT NULL
- inquery_date — date — NOT NULL
- inquery_content — varchar(1500) — NOT NULL
- status — varchar(10) — NOT NULL
- inquery_admin — varchar(60) — NOT NULL
- answer_date — date — NOT NULL
- answer_content — varchar(1500) — NOT NULL
- hide — int(1) — NOT NULL
manner
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- assess_id — varchar(50) — NOT NULL
- manner_date — date — NOT NULL
- manner_ — score` — NOT NULL
meal_board
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- board_id — int(5) — Foreign key → common_column.board_id — NOT NULL
member
- member_id — varchar(50) — Primary key — NOT NULL
- university_id — int(4) — Foreign key → university.university_id — NOT NULL
- member_pw — varchar(200) — NOT NULL
- name — varchar(50) — NOT NULL
- gender — varchar(10) — NOT NULL
- email — varchar(50) — NOT NULL
- phone — varchar(50) — NOT NULL
- member_class — varchar(15) — NOT NULL
- member_status — varchar(10) — NOT NULL
- reg_date — date — NOT NULL
- time_manner — float — NOT NULL
- kind_manner — float — NOT NULL
- resp_manner — float — NOT NULL
- hide — int(1) — NOT NULL
participant
- pt_id — VARCHAR(255) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- board_id — int(5) — Foreign key → common_column.board_id — NOT NULL
- hide — int(1) — NOT NULL
penalty
- penalty_id — int(10) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- penalty_admin — varchar(50) — NOT NULL
- penalty_date — date — NOT NULL
- penalty_end — date — NOT NULL
- pntCancel_id — varchar(50)
- reason — varchar(150)
- cancel — int(1) — NOT NULL
photo
- photo_id — int(10) — Primary key — NOT NULL
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- board_id — int(5) — NOT NULL
report
- report_id — int(10) — Primary key — NOT NULL
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- board_id — int(10) — NOT NULL
- reporter_id — varchar(50) — NOT NULL
- report_date — date — NOT NULL
- report_content — varchar(500)
- report_admin — varchar(50)
- reason — varchar(150)
- status — varchar(20) — NOT NULL
taxi_board
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- board_id — int(5) — Foreign key → common_column.board_id — NOT NULL
- destination — varchar(200) — NOT NULL
university
- university_id — int(4) — Primary key — NOT NULL
- university_name — varchar(100) — NOT NULL
- university_location — varchar(10) — NOT NULL
- university_addr — varchar(500)