asd
Tables (9)
code_detail
- is_active — boolean — NOT NULL
- sort_order — integer — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- code_id — varchar(255) — NOT NULL
- code_name — varchar(255)
- code_value — varchar(255)
- group_id — varchar(255) — Foreign key → code_group.group_id
code_group
- created_at — timestamp(6)
- updated_at — timestamp(6)
- description — varchar(255)
- group_id — varchar(255) — NOT NULL
- group_name — varchar(255)
payment
- amount — integer — NOT NULL
- approved_at — timestamp(6)
- reservation_id — bigint — Foreign key → reservation.id — NOT NULL
- approval_number — varchar(255)
- email — varchar(255)
- id — varchar(255) — NOT NULL
- name — varchar(255)
- status — varchar(255)
- type — varchar(255)
petsitter
- is_approved — boolean
- price — integer — NOT NULL
- id — bigint
- user_id — bigint — Foreign key → users.id — NOT NULL
- available_time — varchar(255)
- experience — varchar(255)
- introduction — varchar(255)
- location — varchar(255)
petsitter_certifications
- petsitter_id — bigint — Foreign key → petsitter.id — NOT NULL
- certification — varchar(255)
petsitter_code
- id — bigint
- petsitter_id — bigint — Foreign key → petsitter.id — NOT NULL
- group_id — varchar(255) — Foreign key → code_group.group_id — NOT NULL
petsitter_services
- petsitter_id — bigint — Foreign key → petsitter.id — NOT NULL
- service — varchar(255)
reservation
- price — integer — NOT NULL
- id — bigint
- petsitter_id — bigint — Foreign key → petsitter.id — NOT NULL
- requested_at — timestamp(6)
- reservation_end_at — timestamp(6)
- reservation_start_at — timestamp(6)
- user_id — bigint — Foreign key → users.id — NOT NULL
- description — varchar(255)
- status — varchar(255)
users
- is_admin — boolean — NOT NULL
- id — bigint
- last_modified_date — timestamp(6)
- signup_date — timestamp(6)
- avatar — varchar(255)
- email — varchar(255)
- name — varchar(255)
- password — varchar(255)
- phone — varchar(255)