Nyangmunity

Tables (5)

Image (이미지)

  • Id (Image_id) — varchar(255) — Primary key — NOT NULL
  • petId (pet_id) — bigint — Foreign key → Pet.Id — NOT NULL
  • url — varchar(255)
  • provider — varchar(50)

Member (사용자)

  • Id (member_id) — bigint — Primary key — NOT NULL
  • email — varchar(255)
  • password — varchar(255)
  • nickname — varchar(255)
  • createDate — datetime(6)

Pet (반려동물)

  • Id (pet_id) — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Member.Id — NOT NULL
  • name — varchar(255)
  • gender — varchar(255)
  • birthday — datetime(6)

Post (게시글)

  • Id (board_id) — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Member.Id — NOT NULL
  • content — text
  • createDate — datetime(6)

PostImage (게시글 관련 이미지)

  • id (post_image_id) — bigint — Primary key — NOT NULL
  • board_id — bigint — Foreign key → Post.Id — NOT NULL
  • image_id (Image_id) — varchar(255) — Foreign key → Image.Id — NOT NULL