Marigold
Tables (8)
AdoptionAdopter (adoption_adopters)
- id (Key) — bigint — Primary key — NOT NULL
- adoption_post_id (Key3) — bigint — Foreign key → AdoptionPost.id — NOT NULL
- adopter_id (Key2) — bigint — Foreign key → User.id — NOT NULL
- created_at (Field3) — datetime(6)
AdoptionPost (adoption_post)
- id (Key) — bigint — Primary key — NOT NULL
- writer_id (Key2) — bigint — Foreign key → User.id — NOT NULL
- status (Field2) — enum('COMPLETED','PROCEEDING','RESERVED')
- created_at (Field3) — datetime(6)
- modified_at (Field4) — datetime(6)
- title (Field5) — varchar(255)
- age (Field6) — int
- weight (Field7) — double
- area (Field8) — varchar(255)
- features (Field9) — text
- neutering (Field10) — enum('NO','UNKNOWN','YES')
- sex (Field11) — enum('FEMALE','MALE','OTHER','UNKNOWN')
- species (Field12) — enum('BIRDS','CAT','DOG','FISH','OTHER','REPTILES','RODENTS')
AdoptionPostImage (adoption_post_image)
- id (Key) — binary(16) — Primary key — NOT NULL
- adoption_post_id (Key2) — bigint — Foreign key → AdoptionPost.id — NOT NULL
- original_file_name (Field2) — varchar(255)
- stored_file_name (Field3) — varchar(255)
- created_at (Field4) — datetime(6)
ChatMessage (chat_messages)
- id (Key) — bigint — Primary key — NOT NULL
- chat_room_id (Key2) — bigint — Foreign key → ChatRoom.id — NOT NULL
- sender_id (Key3) — bigint — Foreign key → User.id — NOT NULL
- message (Field3) — text
- created_at (Field4) — datetime(6)
ChatRoom (chat_rooms)
- id (Key) — bigint — Primary key — NOT NULL
- adoption_post_id (Key2) — bigint — Foreign key → AdoptionPost.id — NOT NULL
- created_at (Field4) — datetime(6)
RoomParticipant (room_participants)
- id (Key) — bigint — Primary key — NOT NULL
- chat_room_id (Key3) — bigint — Foreign key → ChatRoom.id — NOT NULL
- user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
- joined_at (Field3) — datetime(6)
- leaved_at (Field4) — datetime(6)
- is_exited (Field5) — bit(1)
User (users)
- id (Key) — bigint — Primary key — NOT NULL
- image_id (Key2) — binary(16) — Foreign key → UserImage.id — NOT NULL
- provider_info (Field1) — enum('KAKAO','NAVER')
- provider_id (Field2) — varchar(255)
- email (Field3) — varchar(255)
- password (Field4) — varcahr(255)
- nickname (Field5) — varchar(50) — NOT NULL
- role (Field6) — enum('ROLE_ADMIN','ROLE_PERSON') — NOT NULL
- status (Field7) — enum('ACTIVE','BANNED','DELETED','SLEEP') — NOT NULL
- deleted_at (Field8) — datetime(6)
- image_id (Field9) — binary(16)
UserImage (user_image)
- id (Key) — binary(16) — Primary key — NOT NULL
- created_at (Field) — datetime(6)
- original_file_name (Field2) — varchar(255)
- stored_file_name (Field3) — varchar(255)