투펫 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