SSAFY 관통
테이블 (4)
attraction_info (Untitled)
- content_id (Key) — int — 기본 키 — NOT NULL
- content_type_id (Field1) — int
- title (Field2) — varchar(100)
- addr1 (Field3) — varchar(100)
- addr2 (Field4) — varchar(50)
- zipcode (Field5) — varchar(50)
- tel (Field6) — varchar(50)
- first_image (Field7) — varchar(200)
- first_image2 (Field9) — varchar(200)
- readcount (Field10) — int
- sido_code (Field11) — int
- gugun_code (Field12) — int
- latitude (Field13) — decimal(20,17)
- longitude (Field14) — decimal(20,17)
- mlevel (Field15) — varchar(2)
- Field8
boards (Untitled4)
- article_no (Key) — int — 기본 키 — NOT NULL
- user_id (Field) — varchar(16)
- subject (Field2) — varchar(60)
- content (Field3) — text
- hit (Field4) — int
- register_time (Field5) — timestamp
members (Untitled3)
- id (Key) — int — 기본 키 — NOT NULL
- user_id (Field) — varchar(16)
- user_name (Field2) — varchar(60)
- user_password (Field3) — varchar(20)
- user_email (Field4) — varchar(60)
sido (Untitled2)
- sido_code (Key) — int — 기본 키 — NOT NULL
- sido_name (Field) — varchar(30)