community

Tables (9)

board

  • bo_num — int
  • bo_co_num — int — Foreign key → community.co_num — NOT NULL
  • bo_me_id — varchar(13) — Foreign key → member.me_id — NOT NULL
  • bo_title — varchar(50) — NOT NULL
  • bo_content — text — NOT NULL
  • bo_view — int — NOT NULL
  • bo_report_count — int — NOT NULL

comment

  • cm_num — int
  • cm_bo_num — int — Foreign key → board.bo_num — NOT NULL
  • cm_me_id — varchar(13) — Foreign key → member.me_id — NOT NULL
  • cm_content — text — NOT NULL

community

  • co_num — int
  • co_name — varchar(10) — NOT NULL

file

  • fi_num — int
  • fi_bo_num — int — Foreign key → board.bo_num — NOT NULL
  • fi_name — varchar(150) — NOT NULL
  • fi_ori_name — varchar(50) — NOT NULL

member

  • me_id — varchar(13)
  • me_ms_state — varchar(10) — Foreign key → member_state.ms_state — NOT NULL
  • me_pw — varchar(15) — NOT NULL
  • me_email — varchar(30) — NOT NULL
  • me_authority — varchar(5) — NOT NULL
  • me_stop — datetime
  • me_fail — int — NOT NULL

member_state

  • ms_state — varchar(10)

recommend

  • re_num — int
  • re_me_id — varchar(13) — Foreign key → member.me_id — NOT NULL
  • re_bo_num — int — Foreign key → board.bo_num — NOT NULL
  • re_state — int — NOT NULL

report

  • rp_num — int
  • rp_me_id — varchar(13) — Foreign key → member.me_id — NOT NULL
  • rp_rt_name — varchar(15) — Foreign key → report_type.rt_name — NOT NULL
  • rp_table — varchar(10) — NOT NULL
  • rp_content — text — NOT NULL
  • rp_state — varchar(5) — NOT NULL
  • rp_target — int — NOT NULL

report_type

  • rt_name — varchar(15)