PetCampus
Tables (19)
Admin (Untitled21)
- admin_id (Key) — Long — Primary key — NOT NULL
- id (Field) — String
- name (Field2) — String
- phone_number (Field3) — String
- pwd (Field4) — String
- registration_number (Field5) — String
- role (Field6) — String
- registered_date (Field7) — LocalDate
- profile_image_fk (Key2) — Image — Foreign key → Image.image_id — NOT NULL
Agenda (Untitled8)
- agenda_id (Key) — Long — Primary key — NOT NULL
- agenda_note (Field) — String
- snack (Field2) — String
- poop (Field3) — Enum
- poop_memo (Field4) — String
- dog_id_fk (Key2) — Dog — Foreign key → Dog.dog_id — NOT NULL
- status (Field6) — Enum
- reserved_time (Field7) — String
- admin_id_fk (Key3) — Admin — Foreign key → Admin.admin_id — NOT NULL
- date (Field8) — LocalDate
- created_by (Field5) — String
- created_at (Field9) — LocalDateTime
- modified_at (Field10) — LocalDateTime
- modified_by (Field11) — String
Alarm (Untitled9)
- alarm_id (Key) — Long — Primary key — NOT NULL
- category (Field) — Enum
- size (Field2) — Integer
- created_by (Field3) — String
- created_at (Field4) — LocalDateTime
- modified_at (Field5) — LocalDateTime
- modified_by (Field6) — String
AlarmEvent (Untitled10)
- alarm_event_id (Key) — Long — Primary key — NOT NULL
- content_type (Field) — Enum
- content_id (Field2) — Long
- is_read (Field3) — Boolean
- admin_id_fk (Key2) — Long — Foreign key → Admin.admin_id — NOT NULL
- dog_id_fk (Key3) — Long — Foreign key → Dog.dog_id — NOT NULL
- alarm_id_fk (Key4) — Long — Foreign key → Alarm.alarm_id — NOT NULL
- created_by (Field4) — String
- created_at (Field5) — LocalDateTime
- modified_at (Field6) — LocalDateTime
- modified_by (Field7) — String
Attendance (Untitled2)
- attendance_id (Key) — Long — Primary key — NOT NULL
- date (Field) — DateTime
- status (Field3) — Enum
- dog_id_fk (Key3) — Foreign key → Dog.dog_id — NOT NULL
- admin_id_fk (Key2) — Long — Foreign key → Admin.admin_id — NOT NULL
- status (Field4) — Enum
- date_time (Field5) — LocalDateTime
- created_by (Field2) — String
- created_at (Field6) — LocalDateTime
- modified_at (Field7) — LocalDateTime
- modified_by (Field8) — String
Breed (Untitled11)
- breed_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- type (Field2) — String
- unit (Field3) — String
Dog (Untitled4)
- dog_id (Key) — Long — Primary key — NOT NULL
- birth_date (Field2) — LocalDate
- currentRounds (Field3)
- gender (Field4) — Enum
- name (Field7) — String
- size (Field10) — Enum
- member_id_fk (Key2) — Member — Foreign key → Member.member_id — NOT NULL
- school_id_fk (Key3) — School — Foreign key → School.school_id — NOT NULL
- neutralization (Field5) — Enum
- vaccination (Field9) — Enum
- allergyDisease (Field11) — String
- ticket_id_fk (Field12) — Long
- pick_drop_request (Field13) — Enum
- pick_drop_type (Field14) — Enum
- pick_drop_memo (Field15) — Enum
- agreements (Field16)
- dog_memo_by_admin (Field17)
- registered_date (Field18) — LocalDate
- profile_image (Field19) — String
- enrollment_form_id (Field20) — Long
- created_by (Field21) — String
- created_at (Field22) — LocalDateTime
- modified_at (Field23) — LocalDateTime
- modified_by (Field24) — String
- breed (Field) — String
EnrollmentForm (Untitled12)
- enrollment_form_id (Key) — Long — Primary key — NOT NULL
- school_form_id_fk (Key2) — Long — Foreign key → SchoolForm.school_form_id — NOT NULL
- member_id_fk (Field2) — Long
- member_name (Field3) — String
- address (Field4) — String
- address_detail (Field5) — String
- phone_number (Field6) — String
- emergency_phone_number (Field7) — String
- dog_id_fk (Key3) — Foreign key → Dog.dog_id — NOT NULL
- dog_name (Field8) — String
- dog_gender (Field9) — Enum
- dog_size (Field10) — Enum
- breed_id_fk (Field11) — Long
- new_breed (Field12) — String
- dog_birth_date (Field13) — LocalDate
- neutralization (Field14) — Enum
- vaccination (Field15) — Enum
- vaccination_image (Field16) — json
- allergy_disease (Field17) — String
- ticket_type (Field18)
- round_ticket_number (Field19) — int
- monthly_ticket_number (Field20) — int
- attendance_days (Field21)
- pick_drop_request (Field22) — Enum
- pick_dop_type (Field23) — Enum
- agreements (Field24) — json
- status (Field25) — Enum
- registered_date (Field26) — LocalDate
- drop_out_date (Field27) — LocalDate
- member_gender (Field) — Enum
- pick_drop_memo (Field29) — Enum
FCM (Untitled13)
- fcm_id (Key) — Long — Primary key — NOT NULL
- fcm_token (Field) — String
- admin_id_fk (Key2) — Long — Foreign key → Admin.admin_id — NOT NULL
- member_id_fk (Key3) — Long — Foreign key → Member.member_id — NOT NULL
Image (Untitled14)
- image_id (Key) — Long — Primary key — NOT NULL
- dog_id_fk (Key2) — Long — Foreign key → Dog.dog_id — NOT NULL
- image_type (Field) — ImgageType
- comment (Field2) — String
- gruop_id (Field3) — Long
- uri (Field4) — String
- size (Field5) — Int
- created_by (Field6) — String
- created_at (Field7) — LocalDateTime
- modified_at (Field8) — LocalDateTime
- modified_by (Field9) — String
LinkFirebaseAuthMember (Untitled15)
- uid (Key) — String — Primary key — NOT NULL
- member_id_fk (Key2) — Foreign key → Member.member_id — NOT NULL
LinkSchooladmin (Untitled5)
- link_shool_admin_id (Key) — Long — Primary key — NOT NULL
- admin_id_fk (Key2) — Long — Foreign key → Admin.admin_id — NOT NULL
- school_id_fk (Key3) — Foreign key → School.school_id — NOT NULL
- admin_registered_date (Field) — LocalDate
- admin_resigned_date (Field3) — LocalDate
Member (Untitled6)
- member_id (Key) — Long — Primary key — NOT NULL
- email (Field) — String
- name (Field2) — name
- phone_number (Field3) — String
- role (Field4) — Enum
- special_token (Field5)
- gender (Field6)
- address (Field7) — String
- address_detail (Field8) — String
- emergency_phone_number (Field9) — String
- relation (Field11) — String
- nick_name (Field12) — String
- image_id_fk (Key2) — Long — Foreign key → Image.image_id — NOT NULL
Push (Untitled16)
- id (Key) — Long — Primary key — NOT NULL
- accepts_activity (Field) — boolean
- accepts_service (Field2) — Boolean
- accepts_attendance (Field3) — Boolean
- accepts_care (Field4) — Boolean
- accepts_school (Field5) — Boolean
- admin_id_fk (Key2) — Long — Foreign key → Admin.admin_id — NOT NULL
- member_id_fk (Key3) — Long — Foreign key → Member.member_id — NOT NULL
RefreshToken (Untitled17)
- id (Key) — Long — Primary key — NOT NULL
- identifier (Field) — String
- refresh_token (Field2) — String
School (Untitled7)
- school_id (Key) — Long — Primary key — NOT NULL
- address (Field) — String
- name (Field2) — String
- phone_number (Field3) — String
- address_detail (Field4) — String
SchoolForm (Untitled18)
- school_form_id (Key) — Long — Primary key — NOT NULL
- form_name (Field) — String
- school_id_fk (Key2) — Long — Foreign key → School.school_id — NOT NULL
- price_info (Field3) — String
- ticket_type (Field4) — String
- round_ticket_number (Field5) — String
- monthly_ticket_number (Field6) — String
- open_days (Field7)
- ticket_info (Field8) — String
- limit_info (Field9) — String
- accident_info (Field10) — String
- abandonment_info (Field11) — String
- pick_drop_state (Field12) — Enum
- pick_drop_info (Field13) — String
- modified_info_list (Field14)
- is_deleted (Field15) — Boolean
- required_item_list (Field2)
- pick_drop_notice (Field16) — Enum
Ticket (Untitled19)
- ticket_id (Key) — Long — Primary key — NOT NULL
- dog_id_fk (Field) — Long
- ticket_type (Field2) — Enum
- all_rounds (Field3) — Int
- current_rounds (Field4) — Int
- monthly_ticket_number (Field5) — Int
- start_date (Field6) — LocalDate
- expiration_date (Field7) — LocalDate
- attendance_days (Field8)
- created_by (Field9) — String
- created_at (Field10) — LocalDateTime
- modified_at (Field11) — LocalDateTime
- modified_by (Field12) — String
Video (Untitled20)
- video_id (Key) — Long — Primary key — NOT NULL
- original_file_name (Field) — String
- converted_file_name (Field2) — String
- video_url (Field3) — String
- video_thumbnail_url (Field4) — String
- created_by (Field5) — String
- created_at (Field6) — LocalDateTime
- modified_at (Field7) — LocalDateTIme
- modified_by (Field8) — String
- Field9