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
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