지피티와의 세탁소ERP
테이블 (10)
CleaningType
- cleaning_type_id — INT
- name — VARCHAR(100) — NOT NULL
- default_duration — INT
- extra_price — DECIMAL(10,2)
Customer
- customer_id — INT
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- address — VARCHAR(255)
- note — TEXT
- registered_at — DATE
ItemType
- item_type_id — INT
- name — VARCHAR(100) — NOT NULL
- default_price — DECIMAL(10,2)
Order
- order_id — INT
- customer_id — INT — NOT NULL
- received_at — DATE
- status — VARCHAR(50)
- payment_status — VARCHAR(50)
- delivery — BOOLEAN
- pickup_date — DATE
- delivery_date — DATE
OrderItem
- item_id — INT
- order_id — INT — NOT NULL
- item_type_id — INT — NOT NULL
- quantity — INT
- base_price — DECIMAL(10,2)
- request_note — TEXT
- expected_complete — DATE
OrderItemCleaningType
- item_id — INT — 기본 키 — NOT NULL
- cleaning_type_id — INT — 기본 키 — NOT NULL
OrderItemFile
- file_id — INT
- item_id — INT — NOT NULL
- file_url — VARCHAR(255)
- description — TEXT
- uploaded_at — DATE
OrderItemProcess
- item_id — INT — 기본 키 — NOT NULL
- step_id — INT — 기본 키 — NOT NULL
- start_time — DATETIME
- end_time — DATETIME
- status — VARCHAR(50)
Payment
- payment_id — INT
- order_id — INT — NOT NULL
- payment_date — DATE
- payment_method — VARCHAR(50)
- amount — DECIMAL(10,2)
ProcessStep
- step_id — INT
- name — VARCHAR(100) — NOT NULL
- sequence — INT