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')