테스트

테이블 (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)