any몰
테이블 (5)
animals (Untitled2)
- animal (Key) — Primary Key — 기본 키 — NOT NULL
sellComment (Untitled4)
- comment_id (Key) — Primary Key — 기본 키 — NOT NULL
- title (Field)
- price (Field2)
- content (Field3)
- delievery_type (Field4) — "직거래", "택배", "둘다 가능"
- x_coord (Field5)
- y_coord (Field6)
- is_sold (Field7)
- owner (Key2) — Primary Key — 외래 키 → user.log_in_id — NOT NULL
- address (Field8)
- tags (Field9)
sellCommentPict (Untitled5)
- pictUrl (Key) — Primary Key — 기본 키 — NOT NULL
- comment_id (Key2) — Primary Key — 외래 키 → sellComment.comment_id — NOT NULL
user (Untitled)
- log_in_id (Key) — Primary Key — 기본 키 — NOT NULL
- user_name (Field)
- password (Field2)
- phone_numb (Field3)
- x_coord (Field4)
- y_coord (Field5)
- nickname (Field6)
- email_address (Field7)
- profile_pic (Field8)
- open_chatting_link (Field9)
userInterestAni (Untitled3)
- userName (Key) — Primary Key — 외래 키 → user.log_in_id — NOT NULL
- animal (Key2) — Primary Key — 외래 키 → animals.animal — NOT NULL