ssafytrip

Tables (9)

attractions

  • no — int — Primary key — NOT NULL — 명소코드
  • content_type_id — int — Foreign key → contenttypes.content_type_id — 콘텐츠타입
  • area_code — int — Foreign key → sidos.sido_code — 시도코드
  • si_gun_gu_code — int — Foreign key → guguns.gugun_code — 구군코드
  • content_id — int — 콘텐츠번호
  • title — varchar(500) — 명소이름
  • first_image1 — varchar(100) — 이미지경로1
  • first_image2 — varchar(100) — 이미지경로2
  • map_level — int — 줌레벨
  • latitude — decimal(20,17) — 위도
  • longitude — decimal(20,17) — 경도
  • tel — varchar(20) — 전화번호
  • addr1 — varchar(100) — 주소1
  • addr2 — varchar(100) — 주소2
  • homepage — varchar(1000) — 홈페이지
  • overview — varchar(10000) — 설명

b_image

  • image_id — int — Primary key — NOT NULL
  • board_id — int — Foreign key → board.board_id — NOT NULL
  • file_path — varchar(50)
  • file_name — varchar(20)

board

  • board_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • title — varchar(30)
  • content — varchar(500)
  • hit — int

contenttypes

  • content_type_id — int — Primary key — NOT NULL — 콘텐츠타입번호
  • content_type_name — varchar(45) — 콘텐츠타입이름

guguns

  • no — int — Primary key — NOT NULL — 구군번호
  • sido_code — int — Foreign key → sidos.sido_code — NOT NULL — 시도코드
  • gugun_code — int — NOT NULL — 구군코드
  • gugun_name — varchar(20) — 구군이름

sidos

  • no — int — Primary key — NOT NULL — 시도번호
  • sido_code — int — NOT NULL — 시도코드
  • sido_name — varchar(20) — 시도이름

trip_plan

  • plan_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • plan — varchar(200)

trip_snippet

  • trip_id — int — Primary key — NOT NULL
  • no — int — Foreign key → attractions.no — NOT NULL — 명소코드
  • plan_id — int — Foreign key → trip_plan.plan_id — NOT NULL
  • user_id — int — Foreign key → trip_plan.user_id — NOT NULL
  • price — varchar(100)
  • schedule — varchar(200)

user

  • user_id — int — Primary key — NOT NULL
  • password — varchar(15)
  • name — varchar(15)
  • role — varchar(10)
  • email — varchar(40)
  • address — varchar(50)
  • number — varchar(30)