테스트
테이블 (12)
customers
- id — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(100)
- name — VARCHAR(200)
- phone — VARCHAR(20)
- phone_2 — VARCHAR(20)
- regist_date — TIMESTAMP
equipments
- id — INT — 기본 키 — NOT NULL
- customer_id — INT — NOT NULL
- equipment_type — VARCHAR(50) — NOT NULL
- brand — VARCHAR(100)
- model_name — VARCHAR(200)
- serial_number — VARCHAR(100)
- install_date — DATE
- location — VARCHAR(100)
- purchase_date — DATE
- warranty_until — DATE
- memo — TEXT
- regist_date — DATETIME
reservation_service_options
- id — INT — 기본 키 — NOT NULL
- reservation_service_id — INT — NOT NULL
- item_option_id — INT — NOT NULL
- price — INT
- quantity — INT
- option_status — CHAR(1)
reservation_services
- id — INT — 기본 키 — NOT NULL
- reservation_id — INT — NOT NULL
- item_id — INT — NOT NULL
- option_id — INT
- price — INT
- actual_price — INT
- quantity — INT
- item_status — CHAR(1)
- option_name — VARCHAR(1000)
reservations
- id — INT — 기본 키 — NOT NULL
- customer_id — INT — NOT NULL
- center_id — INT — NOT NULL
- technician_id — INT
- equipment_id — INT
- reservation_num — VARCHAR(50)
- total_price — INT
- reserve_date — TIMESTAMP
- scheduled_start — TIMESTAMP
- scheduled_end — TIMESTAMP
- actual_start — TIMESTAMP
- actual_end — TIMESTAMP
- regist_date — TIMESTAMP
- reserve_type — CHAR(1)
- customer_request — VARCHAR(500)
- memo — TEXT
- reservation_status — CHAR(1)
- visit_address — VARCHAR(1000)
service_centers
- id — INT — 기본 키 — NOT NULL
- manager_id — INT — NOT NULL
- name — VARCHAR(500)
- boss_name — VARCHAR(200)
- shop_number — VARCHAR(15)
- phone — VARCHAR(20)
- phone_2 — VARCHAR(20)
- email — VARCHAR(300)
- approval_status — CHAR(1)
- start_time — TIME
- close_time — TIME
- addr1 — VARCHAR(1000)
- addr2 — VARCHAR(1000)
- introduce — TEXT
- reserve_start — TIME
- reserve_close — TIME
- is_reserve_avail — CHAR(1)
- is_open — CHAR(1)
- is_deleted — CHAR(1)
- regist_date — TIMESTAMP
- id (id2) — INT — 외래 키 → customers.id — NOT NULL
service_item_options
- id — INT — 기본 키 — NOT NULL
- item_id — INT — NOT NULL
- name — VARCHAR(1000)
- origin_price — INT
- sale_price — INT
- description — TEXT
- is_deleted — CHAR(1)
- regist_date — DATETIME
- is_visible — CHAR(1)
service_items
- id — INT — 기본 키 — NOT NULL
- center_id — INT — NOT NULL
- name — VARCHAR(300)
- is_visible — CHAR(1)
- description — TEXT — NOT NULL
- regist_date — DATETIME
- is_deleted — CHAR(1)
technician_holidays
- id — INT — 기본 키 — NOT NULL
- technician_id — INT — NOT NULL
- holiday_date — DATE — NOT NULL
- is_deleted — CHAR(1)
technician_schedules
- id — INT — 기본 키 — NOT NULL
- technician_id — INT — NOT NULL
- work_date — DATE — NOT NULL
- time_slot — VARCHAR(20)
- is_deleted — CHAR(1)
technicians
- id — INT — 기본 키 — NOT NULL
- center_id — INT — NOT NULL
- role — CHAR(1)
- user_id — VARCHAR(100)
- passwd — VARCHAR(200)
- name — VARCHAR(200)
- job_grade — VARCHAR(200)
- phone — VARCHAR(20)
- current_status — CHAR(1)
- regist_date — DATETIME
- is_deleted — CHAR(1)
- id (id2) — INT — 외래 키 → service_centers.id — NOT NULL
visit_records
- id — INT — 기본 키 — NOT NULL
- reservation_id — INT — NOT NULL
- technician_id — INT — NOT NULL
- visit_date — DATETIME
- work_start — DATETIME
- work_end — DATETIME
- work_note — TEXT
- parts_used — TEXT
- additional_cost — INT
- is_completed — CHAR(1)
- before_photo — VARCHAR(1000)
- after_photo — VARCHAR(1000)