123

테이블 (6)

notice

  • user_id (2) — 외래 키 → user.Key — NOT NULL
  • title
  • content (Field2)
  • count (Field3)

qna

  • user_id (2) — 외래 키 — NOT NULL
  • user_name
  • title (Field2)
  • content (Field3)
  • answer_email (Field4)

user (Untitled2)

  • Key — 기본 키 — NOT NULL
  • user_name
  • masters_id (Field2)
  • email (Field3)
  • encrypted_password (Field4)

금연구역

  • area_catagory
  • area_name (Field2)
  • latitude (Field3)
  • longitude (Field4)
  • address (Field5)
  • statute (Field6)
  • penalty (Field8)

신고하기

  • user_id (2) — 외래 키 — NOT NULL
  • product_id (3) — 외래 키 — NOT NULL

흡연/단속구역 (Untitled)

  • Key — 기본 키 — NOT NULL
  • area_type
  • area_name (Field2)
  • latitude (Field3)
  • longitude (Field4)
  • address (Field5)
  • image_address (Field6)
  • user_id (Field7)
  • description (Field8)