pawparazzi

Tables (9)

comments

  • comment_id — BIGINT — Primary key
  • post_id (post_id2) — BIGINT — Foreign key → posts.post_id
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • member_id (member_id2) — BIGINT — Foreign key → members.member_id

follows

  • follow_id — BIGINT — Primary key
  • follower — BIGINT — NOT NULL
  • following — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • member_id — BIGINT — Foreign key → members.member_id

likes

  • like_id — BIGINT — Primary key
  • created_at — TIMESTAMP
  • member_id (member_id2) — BIGINT — Foreign key → members.member_id
  • post_id (post_id2) — BIGINT — Foreign key → posts.post_id

members

  • member_id — BIGINT — Primary key
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • userImg — TIMESTAMP

pets

  • pet_id — BIGINT — Primary key
  • name — VARCHAR(50) — NOT NULL
  • type — VARCHAR(50)
  • birth_date — DATE
  • petImg — VARCHAR(255)
  • member_id — BIGINT — Foreign key → members.member_id

places

  • place_id — BIGINT — Primary key
  • category — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • latitude — DECIMAL(9,6)
  • longitude — DECIMAL(9,6)
  • created_at — TIMESTAMP
  • like — TINYINT(1)
  • member_id — BIGINT — Foreign key → members.member_id

posts

  • post_id — BIGINT — Primary key
  • content — TEXT
  • image_url — VARCHAR(255)
  • video_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • member_id (member_id2) — BIGINT — Foreign key → members.member_id

visit_records

  • visit_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • place_id — BIGINT — NOT NULL
  • visit_date — DATE — NOT NULL
  • visit_count — INT
  • created_at — TIMESTAMP

walk_records

  • walk_id — BIGINT — Primary key
  • walk_date — DATE — NOT NULL
  • duration — INT
  • distance — DECIMAL(5,2)
  • location — TEXT
  • created_at — TIMESTAMP
  • pet_id (pet_id2) — BIGINT — Foreign key → pets.pet_id
  • Field