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)