nose-pet
Tables (14)
missing_report (동물 실종 신고)
- idx (Key) — integer — Primary key — NOT NULL
- petIdx (Key3) — integer — Foreign key → pet.idx — NOT NULL
- userIdx (Key4) — integer — Foreign key → user.idx — NOT NULL
- petTypeIdx (Key22) — integer — Foreign key → pet_type.idx — NOT NULL
- type (Field) — enum('MISSING', 'FINDING')
- title (Field2) — varchar(100)
- content (Field3) — text
- missingPlace (Field4) — text
- missingDate (Field5) — text
- memo (Field6) — text
- status (Field7) — enum('ACTIVATED', DONE', 'DELETED', PROTECTED', 'WITNESSED')
missing_report_image (동물 실종 신고 이미지)
- missingReportIdx (Key) — integer — Foreign key → missing_report.idx — NOT NULL
- src (Field) — varchar(300)
- createdDate (Field2) — datetime(6)
- modifiedDate (Field3) — datetime(6)
pet (반려 동물)
- idx (Key) — integer — Primary key — NOT NULL
- userPetGroupIdx (Key3) — integer — Foreign key → user_pet_group.idx — NOT NULL
- petTypeIdx (Key22) — integer — Foreign key → pet_type.idx — NOT NULL
- creatorIdx (Key2) — integer — Foreign key → user.idx — NOT NULL
- name (Field) — varchar(15)
- gender (Field2) — enum('MALE', 'FEMALE')
- isNeutered (Field3) — boolean
- birthDay (Field4) — date
- image (Field5) — varchar(300)
pet_nose_print (반려 동물 비문)
- idx (Key2) — integer — Primary key — NOT NULL
- petIdx (Key) — integer — Foreign key → pet.idx — NOT NULL
pet_schedule (Untitled)
- petIdx (Key) — integer — Foreign key → pet.idx — NOT NULL
- scheduleIdx (Key2) — integer — Foreign key → schedule.idx — NOT NULL
pet_type (동물 종류)
- idx (Key2) — integer — Primary key — NOT NULL
- name (Key) — varchar(30) — NOT NULL
schedule (동물 스케줄)
- idx (Key) — integer — Primary key — NOT NULL
- creatorIdx (Key2) — integer — Foreign key → user.idx — NOT NULL
- userPetGroupIdx (Key3) — integer — Foreign key → user_pet_group.idx — NOT NULL
- title (Field) — varchar(100)
- location (Field2) — varchar(500)
- startDate (Field3) — datetime(6)
- endDate (Field4) — datetime(6)
- type (Field5) — enum('SNACK', 'FOOD', 'HOSPITAL', KINDERGARTEN', 'GROOMING_SALON', 'WALK', 'VITAMIN', 'ETC')
- createdDate (Field6) — datetime(6)
- modifiedDate (Field7) — datetime(6)
- memo (Field9) — text
- status (Field10) — enum('ACTIVATED', 'DEACTIVATED', 'DELETED')
schedule_alarm (동물 스케줄 알람)
- idx (Key) — integer — Primary key — NOT NULL
- schedulerIdx (Key2) — integer — Foreign key → schedule.idx — NOT NULL
- time (Field) — datetime(6)
- status (Field2) — enum('ACTIVATED', 'DEACTIVATED', 'DELETED')
schedule_period_setting (스케줄 주기)
- idx (Key2) — integer — Primary key — NOT NULL
- scheduleIdx (Key) — integer — Foreign key → schedule.idx — NOT NULL
- type (Field) — enum('SUN', 'MON', 'TUE', 'WED', 'THU', 'FRI', 'SAT', 'EVERY_WEEK', 'EVERY_MONTH', 'EVERY_YEAR') — NOT NULL
- endDate (Field2) — date
schedule_vitamin (동물 비타민 기록)
- idx (Key) — integer — Primary key — NOT NULL
- scheduleIdx (Key2) — integer — Foreign key → schedule.idx — NOT NULL
- name (Field) — varchar(50)
- amount (Field2) — integer
schedule_walk (동물 산책)
- idx (Key) — integer — Primary key — NOT NULL
- scheduleIdx (Key2) — integer — Foreign key → schedule.idx — NOT NULL
- time (Field) — varchar(10)
- coordinateList (Field3) — json
- startDate (Field2) — datetime(6)
- endDate (Field4) — datetime(6)
- distance (Field5) — integer
token (토큰)
- idx (Key) — integer — Primary key — NOT NULL
- userIdx (Key2) — integer — Foreign key → user.idx — NOT NULL
- content (Field) — varchar(500)
- expiredDate (Field2) — datetime
- status (Field3) — enum('ACTIVATED', 'DEACTIVATED', 'EXPIRED', 'DEACTIVATED_BY_OTHER_SESSION')
- type (Field4) — enum('LOGIN')
user (유저)
- idx (Key) — integer — Primary key — NOT NULL
- userPetGroupIdx (Key2) — integer — Foreign key → user_pet_group.idx — NOT NULL
- email (Field) — varchar(50)
- password (Field2) — varchar(64)
- name (Field3) — varchar(10)
- nickname (Field4) — varchar(20)
- createdDate (Field5) — datetime(6)
- modifiedDate (Field6) — datetime(6)
user_pet_group (유저 그룹(가족))
- idx (Key) — integer — Primary key — NOT NULL
- name (Field) — vatchar(30)
- status (Field2) — enum('ACTIVATED', 'DEACTIVATED', 'DELETED')