반려동물_관리_시스템

테이블 (12)

Card (Untitled)

  • card_id — BIGINT — 기본 키 — NOT NULL
  • card_number — VARCHAR(64)
  • company — ENUM
  • expire_date — DATE
  • cvv — NUMBER
  • user_id (Key) — BIGINT — 외래 키 → User.user_id — NOT NULL

Order

  • order_id — BIGINT — 기본 키 — NOT NULL
  • user_id (Key) — BIGINT — 외래 키 → User.user_id — NOT NULL
  • total_price — BIGINT

OrderItem (Item)

  • pocket_id — BIGINT — 기본 키 — NOT NULL
  • product_id (Key) — BIGINT — 외래 키 → Product.product_id — NOT NULL
  • order_id (order_id2) — BIGINT — 외래 키 → Order.order_id — NOT NULL
  • quantity — INT
  • price — BIGINT

Payment

  • payment_id (Key) — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → Order.order_id — NOT NULL
  • user_id (Key2) — BIGINT — 외래 키 → User.user_id — NOT NULL
  • card_id — BIGINT — 외래 키 → Card.card_id — NOT NULL
  • simple_pay_id (Key3) — BIGINT — 외래 키 → Simple_pay.simple_pay_id — NOT NULL
  • pay_type (Field) — ENUM('CREDIT','SIMPLE')
  • pay_date — DATETIME
  • total_price — DECIMAL(10,2) — NOT NULL
  • status — ENUM('PENDING', 'CONFIRMED', 'DELIVERED', 'CANCELLED') — NOT NULL

Pet

  • ped_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id (Key3) — BIGINT — 외래 키 → User.user_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • age — INT — NOT NULL
  • photo_url — VARCHAR(255)
  • size — ENUM

Petsitter

  • petsitter_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id (Key2) — BIGINT — 외래 키 → User.user_id — NOT NULL
  • location — VARCHAR(255) — NOT NULL
  • available_pets — ENUM — NOT NULL
  • name — VARCHAR(64)
  • certification_url — VARCHAR(255)
  • description — VARCHAR(255)
  • Certified (certified) — ENUM

Product

  • product_id (Key) — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • amount — INT — NOT NULL
  • description — VARCHAR(255)

Reservation

  • reservation_id (Key3) — BIGINT — 기본 키 — NOT NULL
  • user_id (Key) — BIGINT — 외래 키 → User.user_id — NOT NULL
  • petsitter_id (Key2) — BIGINT — 외래 키 → Petsitter.petsitter_id — NOT NULL
  • simple_pay_id (Key4) — BIGINT — 외래 키 → Simple_pay.simple_pay_id — NOT NULL
  • card_id — BIGINT — 외래 키 → Card.card_id — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME
  • date — DATE — NOT NULL
  • status — ENUM('PENDING', 'CONFIRMED', 'CANCELLED','DONE')) — NOT NULL
  • fee — INT
  • pet_size — ENUM
  • pay_type — ENUM(Credit,Card)

Review (Untitled3)

  • review_id — BIGINT — 기본 키 — NOT NULL
  • reservation_id (Key32) — BIGINT — 외래 키 → Reservation.reservation_id — NOT NULL
  • text — VARCHAR(1024)

Service (Untitled2)

  • service_id — BIGINT — 기본 키 — NOT NULL
  • reservation_id (Key3) — BIGINT — 외래 키 → Reservation.reservation_id — NOT NULL
  • type — ENUM

Simple_pay (SimplePayInfo)

  • simple_pay_id (Key) — BIGINT — 기본 키 — NOT NULL
  • provider — ENUM — NOT NULL
  • created_at — DATETIME
  • pay_key — VARCHAR(64)
  • user_id (Key2) — BIGINT — 외래 키 → User.user_id — NOT NULL

User

  • user_id (Key) — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(64) — NOT NULL
  • password — VARCHAR(64) — NOT NULL
  • name — VARCHAR(32) — NOT NULL
  • role — ENUM('USER', 'ADMIN', 'PETSITTER') — NOT NULL
  • phone — VARCHAR(20)