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)