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