반려동물 모임

테이블 (4)

Untitled (유저미팅)

  • Key (user_metting_id) — bigint — 기본 키 — NOT NULL
  • Key (user_id) — bigint — 외래 키 → 유저.Key — NOT NULL
  • Key (metting_id) — bigint — 외래 키 → Untitled2.Key — NOT NULL
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled2 (모임)

  • Key (metting_id) — bigint — 기본 키 — NOT NULL
  • Field (create_time) — datetime
  • Field (update_time) — datetime
  • Field (description) — varchar(700)
  • Field (end_date_time) — datetime
  • Field (maximum_people) — int
  • Field (meeting_place) — varchar(300)
  • Field (meeting_status) — varchar(255)
  • Field (minum_people) — int
  • Field (participants) — int
  • Field (start_date_time) — datetime
  • Field (title) — varchar(100)

반려동물

  • Key (pet_id) — bigint — 기본 키 — NOT NULL
  • Key (user_id) — bigint — 외래 키 → 유저.Key — NOT NULL
  • Field2 (create_time) — datetime
  • Field3 (update_time) — datetime
  • Field4 (age) — int
  • Field5 (birth_month) — int
  • Field6 (birth_year) — int
  • Field7 (breed) — varchar(255)
  • Field8 (name) — varchar(255)
  • Field9 (neutering) — bit(1)
  • Field10 (pet_gender) — varchar(255)
  • Field (size_type) — varchar(255)

유저

  • Key (user_id) — bigint — 기본 키 — NOT NULL
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime
  • Field3 (city) — varchar(255)
  • Field4 (detail) — varchar(255)
  • Field5 (age) — int
  • Field6 (email) — varchar(255)
  • Field7 (gender) — varchar(255)
  • Field8 (nickname) — varchar(20)
  • Field9 (password) — varchar(100)
  • Field10 (self_introduction) — varchar(100)
  • Field11 (user_name) — varchar(20)
  • Field (user_role) — varchar(255)