pet
Tables (11)
cart
- id — SERIAL — Primary key
- quantity — INTEGER — NOT NULL
- created_at — TIMESTAMP
- user_id — SERIAL — Foreign key → users.user_id — NOT NULL
- product_id — SERIAL — Foreign key → products.product_id
codes
- id — SERIAL — Primary key
- code_group — VARCHAR(100) — NOT NULL
- code_name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
order_items
- id — SERIAL — Primary key
- quantity — INTEGER — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- product_id (product_id3) — SERIAL — Foreign key → products.product_id
- order_id — SERIAL — Foreign key → orders.order_id
orders
- order_id — SERIAL — Primary key
- total_price — DECIMAL(10, 2) — NOT NULL
- status — VARCHAR(50)
- CANCELLED)) — NOT — NOT NULL
- created_at — TIMESTAMP
- user_id — SERIAL — Foreign key → users.user_id — NOT NULL
payments
- order_id (order_id2) — SERIAL — Foreign key → orders.order_id
- payment_gateway — VARCHAR(50) — NOT NULL
- method — ENUM('CARD', 'BANK_TRANSFER', 'KAKAO_PAY', 'TOSS_PAY', 'NAVER_PAY', 'APPLE_PAY') — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- status — ENUM('PENDING', 'COMPLETED', 'FAILED', 'CANCELLED', 'REFUNDED') — NOT NULL
- transaction_id — VARCHAR(255)
- approved_at — TIMESTAMP
- created_at — TIMESTAMP
pets
- id — SERIAL — Primary key
- name — VARCHAR(100) — NOT NULL
- species — VARCHAR(50) — NOT NULL
- age — INTEGER
- photo_url — TEXT
- created_at — TIMESTAMP
- user_id — SERIAL — Foreign key → users.user_id — NOT NULL
petsitter_bookings
- id — SERIAL — Primary key
- user_id — INTEGER
- service_id — INTEGER
- booking_date — TIMESTAMP — NOT NULL
- status — VARCHAR(50)
- CANCELLED)) — NOT — NOT NULL
- created_at — TIMESTAMP
- user_id (user_id3) — SERIAL — Foreign key → users.user_id — NOT NULL
- petsitter_id — SERIAL — Foreign key → petsitters.user_id — NOT NULL
petsitter_services
- id — SERIAL
- petsitter_id — INTEGER
- service_type — VARCHAR(50)
- BOARDING)) — NOT — NOT NULL
- pet_size — VARCHAR(20)
- LARGE)) — NOT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- available_dates — TEXT
petsitters
- user_id (user_id2) — SERIAL — Foreign key → users.user_id — NOT NULL
- location — VARCHAR(255)
- experience — TEXT
- profile_photo — TEXT
- certification — TEXT
- created_at — TIMESTAMP
products
- product_id — SERIAL — Primary key
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- category — VARCHAR(100)
- price — DECIMAL(10, 2) — NOT NULL
- stock — INTEGER — NOT NULL
- image_url — TEXT
- created_at — TIMESTAMP
users
- user_id — SERIAL — Primary key — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- nationality — VARCHAR(50)
- job — VARCHAR(50)
- nickname — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- role — VARCHAR(20)
- ADMIN)) — NOT — NOT NULL
- created_at — TIMESTAMP
- ispetsitter — BOOLEAN