동물특공대

테이블 (10)

address

  • addressId (ID) — bigint — 기본 키 — NOT NULL
  • code (CODE) — int
  • name (NAME) — varchar
  • createdAt (CREATED_AT) — datetime
  • modifiedAt (MODIFIED_AT) — datetime
  • latitude (LATITUDE) — decimal
  • longitude (LONGITUDE) — decimal

info_map

  • infoMapId (ID) — bigint — 기본 키 — NOT NULL
  • name (NAME) — varchar
  • latitude (LATITUDE) — decimal
  • longitude (LONGITUDE) — decimal
  • category (CATEGORY) — varchar
  • createdAt (CREATED_AT) — datetime
  • modifiedAt (MODIFIED_AT) — datetime
  • imageurl (IMAGEURL) — varchar
  • mapAddress (MAP_ADDRESS) — varchar
  • operationTime (OPERATION_TIME) — varchar
  • tel (TEL) — varchar
  • homepage (HOMEPAGE) — varchar
  • addressId (ADDRESS_ID) — bigint — 외래 키 → address.addressId — NOT NULL

info_map_comment

  • COMMENT_ID (ID) — bigint — 기본 키 — NOT NULL
  • INFO_MAP_ID — bigint — 외래 키 → info_map.infoMapId — NOT NULL
  • PET_ID — bigint — 외래 키 → pet.petId — NOT NULL
  • contents (CONTENTS) — varchar
  • createdAt (CREATED_AT) — datetime
  • modifiedAt (MODIFIED_AT) — datetime

pet

  • petId (ID) — bigint — 기본 키 — NOT NULL
  • loginId (LOGIN_ID) — varchar
  • password (PASSWORD) — varchar
  • petname (PET_NAME) — varchar
  • profileImage (PROFILE_IMAGE) — varchar
  • age (AGE) — int
  • gender (GENDER) — varchar
  • addressId (ADDRESS_ID) — bigint — 외래 키 → address.addressId — NOT NULL
  • createdAt (CREADTED_AT) — datetime
  • modifiedAt (MODIFIED_AT) — datetime
  • species (SPECIES) — varchar
  • petStatus (PET_STATUS) — varchar

pet_map

  • STORE_MAP_ID (ID) — bigint — 기본 키 — NOT NULL
  • petId (PET_ID) — bigint — 외래 키 → pet.petId — NOT NULL
  • INFO_MAP_ID — bigint — 외래 키 → info_map.infoMapId — NOT NULL
  • createdAt (CREATED_AT) — datetime
  • modifiedAt (MODIFIED_AT) — datetime

pet_roles

  • petId (PET_ID) — bigint — 외래 키 → pet.petId — NOT NULL
  • roles (ROLES) — varchar

post

  • postId (ID) — bigint — 기본 키 — NOT NULL
  • petId (PET_ID) — bigint — 외래 키 → pet.petId — NOT NULL
  • title (TITLE) — varchar
  • content (CONTENTS) — text
  • createdAt (CREATED_AT) — datetime
  • modifiedAt (MODIFIED_AT) — datetime
  • likesCnt (LIKES_CNT) — int
  • code (CODE) — int

post_comment

  • postCommentId (ID) — bigint — 기본 키 — NOT NULL
  • postId (POST_ID) — bigint — 외래 키 → post.postId — NOT NULL
  • petId (PET_ID) — bigint — 외래 키 → pet.petId — NOT NULL
  • contents (CONTENTS) — varchar
  • createdAt (CREATED_AT) — datetime
  • modifiedAt (MODIFIED_AT) — datetime

post_image

  • imageId (ID) — bigint — 기본 키 — NOT NULL
  • postId (POST_ID) — bigint — 외래 키 → post.postId — NOT NULL
  • imageUrl (IMAGEURL) — varchar
  • originalFileName (ORIGINAL_FILE_NAME) — varchar

post_likes

  • likesId (ID) — bigint — 기본 키 — NOT NULL
  • petId (PET_ID) — bigint — 외래 키 → pet.petId — NOT NULL
  • postId (POST_ID) — bigint — 외래 키 → post.postId — NOT NULL
  • vote_status (VOTE_STATUS) — varchar