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)