sadfasdf
Tables (4)
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`
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`
sidos
- no — INT — Primary key — NOT NULL
- sido_code — INT
- sido_name — VARCHAR(20)