erd
Tables (6)
comm_data
- comm_id — varchar(10) — Foreign key → community.comm_id — NOT NULL
- user_id — varchar(30) — Foreign key → user.user_id — NOT NULL
comment
- comment_id — varchar(50) — Primary key — NOT NULL
- comm_id — varchar(10) — Foreign key → community.comm_id — NOT NULL
- user_id — varchar(30) — Foreign key → user.user_id — NOT NULL
- comment_content — varchar(100) — NOT NULL
community
- comm_id — varchar(10) — Primary key — NOT NULL
- user_id — varchar(30) — Foreign key → user.user_id — NOT NULL
- comm_title — varchar(50) — NOT NULL
- comm_preview — varchar(100) — NOT NULL
- comm_picture — varchar(255)
- comm_info — varchar(255) — NOT NULL
- comm_address — varchar(50) — NOT NULL
- comm_like — int(11)
- comm_date — date
- comm_picname — varchar(50)
- comm_score — int(11)
event
- event_id — varchar(10) — Primary key — NOT NULL
- user_id — varchar(30) — Foreign key → user.user_id — NOT NULL
- event_title — varchar(30) — NOT NULL
- event_preview — varchar(50) — NOT NULL
- event_picture — varchar(255)
- event_address — varchar(255) — NOT NULL
- event_intro — varchar(255)
- event_content — longtext — NOT NULL
- event_phone — varchar(30) — NOT NULL
- event_start_date — date — NOT NULL
- event_end_date — date
- event_like — int(11)
- event_manager — varchar(100)
- event_type — int(11) — NOT NULL
- event_picname — varchar(50)
- event_url — varchar(200)
event_data
- event_id — varchar(10) — Foreign key → event.event_id — NOT NULL
- user_id — varchar(30) — Foreign key → user.user_id — NOT NULL
user
- user_id — varchar(30) — Primary key — NOT NULL
- user_name — varchar(30) — NOT NULL
- user_pswd — varchar(30) — NOT NULL
- user_nickname — varchar(30) — NOT NULL
- user_email — varchar(30) — NOT NULL
- user_type — int(11) — NOT NULL
- user_sex — varchar(5) — NOT NULL
- user_age — int(11) — NOT NULL
- user_fv1 — varchar(50) — NOT NULL
- user_fv2 — varchar(50) — NOT NULL
- user_fv3 — varchar(50) — NOT NULL