test_DB
Tables (8)
Favorite
- user_id — VARCHAR(50) — Primary key — NOT NULL
- spot_no — INT — Primary key — NOT NULL
- created_at — DATETIME
Observation_Condition
- condition_id — INT — NOT NULL
- spot_no — INT — NOT NULL
- date — DATE — NOT NULL
- cloud_coverage — DECIMAL(5,2)
- air_quality — VARCHAR(20)
- humidity — DECIMAL(5,2)
- temperature — DECIMAL(5,2)
- created_at — DATETIME
Review
- review_code — INT — NOT NULL
- spot_no — INT — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- score — INT — NOT NULL
- content — TEXT — NOT NULL
- image — VARCHAR(200)
- likes — INT
- created_at — DATETIME
- updated_at — DATETIME
Review_Like
- user_id — VARCHAR(50) — Primary key — NOT NULL
- review_code — INT — Primary key — NOT NULL
- created_at — DATETIME
Spot
- spot_no — INT — NOT NULL
- spot_name — VARCHAR(100) — NOT NULL
- spot_addr — VARCHAR(200) — NOT NULL
- latitude — DECIMAL(20,17) — NOT NULL
- longitude — DECIMAL(20,17) — NOT NULL
- altitude — INT — NOT NULL
- description — TEXT
- image — VARCHAR(200)
- area_code — INT
- si_gun_gu_code — INT — NOT NULL
- light_pollution — DECIMAL(5,2)
- parking_available — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
User
- user_id — VARCHAR(50) — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- password — VARCHAR(200) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(200)
- created_at — DATETIME
- region — INT
guguns
- guguns_no — INT — NOT NULL
- sido_code — INT — NOT NULL
- gugun_code — INT — NOT NULL
- gugun_name — VARCHAR(20) — NOT NULL
sidos
- sidos_no — INT — NOT NULL
- sido_code — INT — NOT NULL
- sido_name — VARCHAR(20) — NOT NULL