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)