werin
Tables (15)
bbs
- bbs_id — int — Primary key — NOT NULL
- bbs_cate — varchar(100) — NOT NULL
- bbs_title — varchar(100) — NOT NULL
- bbs_content — varchar(100) — NOT NULL
- bbs_writer — varchar(100) — Foreign key → member.member_id — NOT NULL
- bbs_created_at — datetime
- bbs_total_like — int
- bbs_view — int
- bbs_img — varchar(100)
bbs_cmt
- bbscmt_id — int — Primary key — NOT NULL
- bbs_id — int — Foreign key → bbs.bbs_id — NOT NULL
- bbscmt_writer — varchar(100) — Foreign key → member.member_id — NOT NULL
- bbscmt_content — varchar(100)
- bbscmt_created_at — datetime
- bbscmt_updated_at — datetime
bbs_like
- like_id — int — Primary key — NOT NULL
- bbs_id — int — Foreign key → bbs.bbs_id — NOT NULL
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- like_state — int — NOT NULL
gowith
- gowith_id — int — Primary key — NOT NULL
- gowith_title — varchar(100) — NOT NULL
- gowith_content — varchar(3000) — NOT NULL
- gowith_writer — varchar(100) — Foreign key → member.member_id — NOT NULL
- gowith_created_at — datetime
- gowith_view — int
- gowith_total_like — int
- gowith_total_dislike — int
- gowith_img — varchar(100)
gowith_total_like
- like_id — int — Primary key — NOT NULL
- gowith_id — int — Foreign key → gowith.gowith_id — NOT NULL
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL
- like_state — int
gowithcmt
- gowithcmt_id — int — Primary key — NOT NULL
- gowith_id — int — Foreign key → gowith.gowith_id — NOT NULL
- gowithcmt_writer — varchar(100) — Foreign key → member.member_id — NOT NULL
- gowithcmt_content — varchar(3000) — NOT NULL
- gowithcmt_created_at — datetime
- gowithcmt_updated_at — datetime
landmarkinfo
- landmarkinfo_id — int — Primary key — NOT NULL
- landmarkinfo_name — varchar(100)
- landmarkinfo_pic — varchar(100)
- landmarkinfo_lat — double
- landmarkinfo_lon — double
- landmarkinfo_contentid — int
landmarkinfo2
- overview — varchar(4000)
- addr1 — varchar(100)
- title — varchar(100)
- firstImage2 — varchar(100)
- mapx — varchar(100)
- mapy — varchar(100)
- tel — varchar(100)
- homepage — varchar(1000)
member
- member_id — varchar(100) — Primary key — NOT NULL
- member_pw — varchar(100) — NOT NULL
- member_name — varchar(100) — NOT NULL
- member_nickname — varchar(100) — NOT NULL
- member_tel — varchar(100) — NOT NULL
- member_email — varchar(100) — NOT NULL
- member_gender — varchar(100) — NOT NULL
- member_grade — varchar(100)
- member_level — int — NOT NULL
- variation — int
message
- message_id — int — Primary key — NOT NULL
- room_id — int — Foreign key → room.room_id — NOT NULL
- message_receiver — varchar(100) — Foreign key → member.member_id — NOT NULL
- message_sender — varchar(100) — Foreign key → member.member_id — NOT NULL
- message_content — varchar(3000) — NOT NULL
- message_sent_at — datetime
plan
- plan_no — int — Primary key — NOT NULL
- plan_title — varchar(100) — NOT NULL
- plan_start_date — date
- plan_end_date — date
- plan_writer — varchar(100) — Foreign key → member.member_id — NOT NULL
- plan_with — varchar(100)
room
- room_id — int — Primary key — NOT NULL
- room_name — varchar(100) — NOT NULL
- gowith_id — int — Foreign key → gowith.gowith_id — NOT NULL
- room_host — varchar(100) — NOT NULL
- room_member — varchar(100) — Foreign key → member.member_id — NOT NULL
- room_created_at — datetime
- room_flag — varchar(100)
schedule
- schedule_id — int — Primary key — NOT NULL
- schedule_title — varchar(1000)
- schedule_map_lat — varchar(100)
- schedule_map_lon — varchar(100)
- schedule_day — varchar(100) — NOT NULL
- schedule_plan_no — int — Foreign key → plan.plan_no — NOT NULL
trip
- trip_id — int — Primary key — NOT NULL
- trip_title — varchar(100) — NOT NULL
- trip_content — varchar(4000) — NOT NULL
- trip_start_date — date — NOT NULL
- trip_end_date — date — NOT NULL
- trip_writer — varchar(100) — Foreign key → member.member_id — NOT NULL
- trip_writedate — datetime — NOT NULL
- trip_count — int — NOT NULL
- trip_total_like — int — NOT NULL
- trip_img — varchar(100)
trip_like
- like_id — int — Primary key — NOT NULL — 추천 식별 id
- trip_id — int — NOT NULL — 추천 게시글 식별 id
- member_id — varchar(100) — Foreign key → member.member_id — NOT NULL — 추천을 누른 사람의 멤버 id
- like_state — int — 추천 == 0 // 비추천 == 1