project
Tables (20)
alarm
- alarm_idx — 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_idx — int(10) — Primary key — NOT NULL
- board_idx — int(5) — Foreign key → board_common_column.board_idx — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- apply_date — date — NOT NULL
- investment — varchar(10) — NOT NULL
- status — varchar(10) — NOT NULL
blind_board
- blind_idx — 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_idx — int(5) — NOT NULL
- subject — varchar(150) — NOT NULL
- blind_date — date — NOT NULL
- blind_reason — varchar(15) — NOT NULL
- blindCancel_id — varchar(50)
- blindCancel_reason — varchar(150)
- cancel — int(1) — NOT NULL
block
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- block_member — varchar(50) — NOT NULL
board_common_column
- board_idx — 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
- deadline — date — NOT NULL
- appoint_place — varchar(200) — NOT NULL
- appoint_coords_lat — varchar(200) — NOT NULL
- appoint_coords_lng — 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
category
- category_id — varchar(20) — Primary key — NOT NULL
certificate
- certificate_idx — int(10) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- oriFileName — varchar(50) — NOT NULL
- newFileName — varchar(50) — NOT NULL
delivery_board
- board_idx — int(5) — Foreign key → board_common_column.board_idx — NOT NULL
- min_delivery — varchar(10) — NOT NULL
- delivery_fee — varchar(10) — NOT NULL
- min_fund — varchar(10) — NOT NULL
history
- history_idx — int(10) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- board_idx — int(5) — Foreign key → board_common_column.board_idx — NOT NULL
- hide — int(1) — NOT NULL
inquery
- inquery_idx — 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)
- answer_date — date
- answer_content — varchar(1500)
- hide — int(1) — NOT NULL
manner_assess
- assess_idx — 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_idx — int(5) — Foreign key → board_common_column.board_idx — NOT NULL
- assessor — varchar(50) — NOT NULL
- assess_date — date — NOT NULL
- manner_ — score` — NOT NULL
manner_score
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- avg_score — float — NOT NULL
meal_board
- board_idx — int(5) — Foreign key → board_common_column.board_idx — NOT NULL
member
- member_id — varchar(50) — Primary key — NOT NULL
- university_idx — int(4) — Foreign key → university.university_idx — 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
- certficate_chk — int(1) — NOT NULL
- hide — int(1) — NOT NULL
participant
- pt_idx — int(10) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- board_idx — int(5) — Foreign key → board_common_column.board_idx — NOT NULL
- hide — int(1) — NOT NULL
penalty
- penalty_idx — int(10) — Primary key — NOT NULL
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- report_idx — int(10) — NOT NULL
- penalty_admin — varchar(50) — NOT NULL
- penalty_reason — varchar(500) — NOT NULL
- penalty_date — date — NOT NULL
- penalty_end — date — NOT NULL
- pntCancel_id — varchar(50)
- pntCancel_reason — varchar(150)
- cancel — int(1) — NOT NULL
photo
- photo_idx — int(10) — Primary key — NOT NULL
- category_id — varchar(20) — Foreign key → category.category_id — NOT NULL
- board_idx — int(5) — NOT NULL
- oriFileName — varchar(50) — NOT NULL
- newFileName — varchar(50) — NOT NULL
report
- report_idx — int(10) — Primary key — NOT NULL
- board_idx — int(5) — Foreign key → board_common_column.board_idx — NOT NULL
- reporter_id — varchar(50) — NOT NULL
- report_date — date — NOT NULL
- report_content — varchar(500)
- report_admin — varchar(50)
- report_reason — varchar(150)
- status — varchar(20) — NOT NULL
taxi_board
- board_idx — int(5) — Foreign key → board_common_column.board_idx — NOT NULL
- destination — varchar(200) — NOT NULL
university
- university_idx — int(4) — Primary key — NOT NULL
- university_name — varchar(100) — NOT NULL
- university_location — varchar(10) — NOT NULL
- university_addr — varchar(500)