KT_PETSITTER
Tables (13)
Admins
- admin_id — INT
- user_id — INT — NOT NULL
Cart
- cart_id — INT
- user_id — INT — NOT NULL
- item_id — INT — NOT NULL
- quantity — INT — NOT NULL
Orders
- order_id — INT
- user_id — INT — NOT NULL
- order_date — TIMESTAMP
- payment_method_code — VARCHAR(10)
- status — VARCHAR(20)
- total_price — DECIMAL(10, 2)
PaymentMethods
- payment_method_code — VARCHAR(10)
- method_description — VARCHAR(50) — NOT NULL
Permissions
- permission_id — INT
- role_id — INT — NOT NULL
- permission_description — TEXT — NOT NULL
PetSitterReservations
- reservation_id — INT
- user_id — INT — NOT NULL
- sitter_id — INT — NOT NULL
- date — DATE — NOT NULL
- time_slot — VARCHAR(50)
- status — VARCHAR(20)
PetSitters
- sitter_id — INT
- user_id — INT — NOT NULL
- name — VARCHAR(100)
- contact_info — VARCHAR(50)
- location — VARCHAR(100)
- experience — TEXT
- available_services — TEXT
- rate_per_hour — DECIMAL(10, 2)
- profile_photo_url — VARCHAR(255)
PetTypes
- type_code — VARCHAR(10)
- type_description — VARCHAR(50) — NOT NULL
Pets
- pet_id — INT
- user_id — INT — NOT NULL
- name — VARCHAR(50)
- type_code — VARCHAR(10)
- age — INT
- photo_url — VARCHAR(255)
Roles
- role_id — INT
- role_name — VARCHAR(50) — NOT NULL
- role_description — TEXT
Shopping
- item_id — INT
- name — VARCHAR(100)
- category — VARCHAR(50)
- price — DECIMAL(10, 2)
- description — TEXT
- stock — INT
- created_at — TIMESTAMP
UserJobCodes
- job_code — VARCHAR(10)
- job_description — VARCHAR(50) — NOT NULL
Users
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- nationality — VARCHAR(50)
- job_code — VARCHAR(10)
- nickname — VARCHAR(50)
- phone_number — VARCHAR(20)
- role_id — INT
- created_at — TIMESTAMP