동물특공대
테이블 (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