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