ssafy
Tables (9)
H_board
- article_no — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → userinfo.user_id — NOT NULL
- no — INT — Foreign key → attractions.no — NOT NULL
- title — varchar(45)
- content — longtext
- time — timestamp
attractions
- no — INT — Primary key — NOT NULL
- content_id — INT
- title — VARCHAR(500)
- 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
- first_image1 — VARCHAR(100)
- first_image2 — VARCHAR(100)
- map_level — INT
- latitude — DECIMAL(20,17)
- longitude — DECIMAL(20,17)
- tel — VARCHAR(20)
- addr1 — VARCHAR(100)
- addr2 — VARCHAR(100)
- homepage — VARCHAR(1000)
- overview — VARCHAR(10000)
- INDEX — `attractions_typeid_to_types_typeid_fk_idx`
- INDEX — `attractions_sido_to_sidos_code_fk_idx`
- INDEX — `attractions_sigungu_to_guguns_gugun_fk_idx`
comment
- comment_id — int — Primary key — NOT NULL
- article_no — int — Foreign key → H_board.article_no — NOT NULL
- c_user_id — varchar(20) — Foreign key → userinfo.user_id — NOT NULL
- c_content — varchar(100)
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
- gugun_code — INT
- gugun_name — VARCHAR(20)
- INDEX — `guguns_sido_to_sidos_cdoe_fk_idx`
- INDEX — `gugun_code_idx`
r_element
- r_element_id — int — Primary key — NOT NULL
- route_id — int — Foreign key → user_route.route_id — NOT NULL
- no — INT — Foreign key → attractions.no — NOT NULL
- order — int
sidos
- no — INT — Primary key — NOT NULL
- sido_code — INT
- sido_name — VARCHAR(20)
user_route
- route_id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → userinfo.user_id — NOT NULL
- route_title — varchar(30)
userinfo
- user_id (id) — varchar(20) — Primary key — NOT NULL
- password — varchar(30)
- age — int
- gender — varchar(3)
- email — varchar(30)