communities
Tables (3)
communities
- commu_no — int — Primary key — NOT NULL
- commu_id — varchar(20) — Foreign key → user.user_id — NOT NULL
- commu_title — varchar(200) — NOT NULL
- commu_content — varchar(1000) — NOT NULL
- commu_img — varchar(500)
- commu_img2 — varchar(500)
- commu_img3 — varchar(500)
- category1 — varchar(200) — NOT NULL
- commu_view — int
- commu_date — timestamp
reply
- reply_no — int — Primary key — NOT NULL
- reply_id — varchar(20) — Foreign key → user.user_id
- reply_content — varchar(300)
- commu_no — int — Foreign key → communities.commu_no
- reply_date — timestamp
user
- user_id — varchar(20) — Primary key — NOT NULL
- user_pw — varchar(20) — NOT NULL
- user_email — varchar(100) — NOT NULL
- user_tel — varchar(20) — NOT NULL
- user_nickname — varchar(20) — NOT NULL
- user_img — varchar(500)
- user_level — varchar(20) — NOT NULL
- user_interest — varchar(20)
- user_state — tinyint(1) — NOT NULL
- user_joindate — timestamp — NOT NULL
- user_visit — int — NOT NULL
- user_name — varchar(100) — NOT NULL
- user_addr1 — varchar(100) — NOT NULL
- user_addr2 — varchar(100) — NOT NULL
- user_addr3 — varchar(100) — NOT NULL
- user_addr4 — varchar(100) — NOT NULL
- user_addr5 — varchar(100)
- user_recentvisit — date
- user_commu — int
- user_reply — int