투펫 eng

테이블 (9)

comment (Untitled7)

  • comment_num (Key2) — 기본 키 — NOT NULL
  • comment_content (Field)
  • comment_date (Field2)
  • post_num (Key) — 외래 키 → post.post_num — NOT NULL
  • id (Key3) — 외래 키 → member.id — NOT NULL

facility (Untitled2)

  • fac_num (Key) — 기본 키 — NOT NULL
  • fac_name (Field)
  • fac_tel (Field3)
  • fac_address (Field2)
  • fac_kind (Field4)
  • fac_limit (Field5)
  • fac_time (Field6)
  • fac_site (Field8)
  • fac_parking (Field9)
  • fac_charge (Field11)
  • fac_holiday (Field10)
  • fac_latitude (Field7)
  • fac_longitude (Field12)

favorite (즐겨찾기)

  • id (Key) — 외래 키 → member.id — NOT NULL
  • fac_num (Key2) — 외래 키 → facility.fac_num — NOT NULL
  • fav_name (Field)
  • fav_content (Field2)

member (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • password (Field)
  • name (Field2)
  • email (Field3)
  • birth (Field4)
  • gender (Field5)
  • phonenum (Field6)
  • admin (Field7)

pet (Untitled6)

  • pet_num (Key) — 기본 키 — NOT NULL
  • pet_kind (Field)
  • pet_weight (Field2)
  • id (Key2) — 외래 키 → member.id — NOT NULL

post (Untitled5)

  • post_num (Key) — 기본 키 — NOT NULL
  • post_title (Field4)
  • post_content (Field)
  • post_type (Field2)
  • post_date (Field3)
  • post_views (Field5)
  • post_great (Field6)
  • id (Key2) — 외래 키 → member.id — NOT NULL

report (Untitled8)

  • report_num — 기본 키 — NOT NULL
  • report_reason
  • report_id — 외래 키 → member.id — NOT NULL
  • post_num (Key3) — 외래 키 → post.post_num — NOT NULL
  • comment_num (Key22) — 외래 키 → comment.comment_num — NOT NULL

reserve (Untitled3)

  • res_num (Key) — 기본 키 — NOT NULL
  • res_date (Field)
  • res_peoples (Field2)
  • id (Key2) — 외래 키 → member.id — NOT NULL
  • fac_num (Key3) — 외래 키 → facility.fac_num — NOT NULL

review (Untitled4)

  • review_num (Key) — 기본 키 — NOT NULL
  • review_info (Field)
  • review_date (Field3)
  • review_grade (Field2)
  • id (Key2) — 외래 키 → member.id — NOT NULL
  • fac_num (Key3) — 외래 키 → facility.fac_num — NOT NULL