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