ㄴㄴㄴ
Tables (12)
Calendar
- id — VARCHAR(255)
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- status — ENUM('AVAILABLE','RESERVED','CANCELLED')
Cart
- id — VARCHAR(255)
- customer_id — VARCHAR(255) — NOT NULL
- product_id — VARCHAR(255) — NOT NULL
- quantity — INT
- created_at — TIMESTAMP
ChatRoom
- id — VARCHAR(255)
- customer_id — VARCHAR(255) — NOT NULL
- owner_id — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
Chatting
- id — VARCHAR(255)
- chatroom_id — VARCHAR(255) — NOT NULL
- sender_type — ENUM('CUSTOMER','OWNER') — NOT NULL
- sender_id — VARCHAR(255) — NOT NULL
- message — TEXT
- send_time — TIMESTAMP
Customer
- id — VARCHAR(255)
- name — VARCHAR(255)
- profile_picture — VARCHAR(255)
- age — INT
- email — VARCHAR(255)
- phone_number — VARCHAR(255)
- address — VARCHAR(255)
- created_at — TIMESTAMP
Notification
- id — VARCHAR(255)
- receiver_id — VARCHAR(255) — NOT NULL
- type — ENUM('RESERVATION','PAYMENT','MESSAGE','SYSTEM')
- message — TEXT
- is_read — BOOLEAN
- created_at — TIMESTAMP
Owner
- id — VARCHAR(255)
- name — VARCHAR(255)
- profile_picture — VARCHAR(255)
- phone_number — VARCHAR(255)
- address — VARCHAR(255)
- business_registration_number — VARCHAR(255)
- created_at — TIMESTAMP
Payment
- id — VARCHAR(255)
- customer_id — VARCHAR(255) — NOT NULL
- reservation_id — VARCHAR(255) — NOT NULL
- amount — DECIMAL(12,2) — NOT NULL
- payment_method — ENUM('CARD','BANK_TRANSFER','KAKAO_PAY','NAVER_PAY') — NOT NULL
- status — ENUM('PENDING','COMPLETED','FAILED','REFUNDED')
- paid_at — TIMESTAMP
Product
- id — VARCHAR(255)
- owner_id — VARCHAR(255) — NOT NULL
- category — ENUM('STUDIO','DRESS','MAKEUP') — NOT NULL
- title — VARCHAR(255)
- details — TEXT
- price — DECIMAL(12,2)
- views — INT
- address — VARCHAR(255)
- main_picture — VARCHAR(255)
- created_at — TIMESTAMP
ProductOption
- option_id — VARCHAR(255)
- product_id — VARCHAR(255) — NOT NULL
- option_name — VARCHAR(255)
- option_price — DECIMAL(12,2)
- option_description — VARCHAR(255)
Reservation
- id — VARCHAR(255)
- customer_id — VARCHAR(255) — NOT NULL
- product_id — VARCHAR(255) — NOT NULL
- calendar_id — VARCHAR(255) — NOT NULL
- status — ENUM('PENDING','CONFIRMED','CANCELLED')
- created_at — TIMESTAMP
Review
- id — VARCHAR(255)
- product_id — VARCHAR(255) — NOT NULL
- customer_id — VARCHAR(255) — NOT NULL
- comment — TEXT — EX
- star — INT
- picture — VARCHAR(255)
- created_at — TIMESTAMP