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