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