반려동물_관리_시스템
테이블 (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)