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)