레이저 견적 플랫폼
테이블 (22)
Drawing (도면)
- id (PK) — Long — 기본 키 — NOT NULL
- order_id (FK1) — Long — 외래 키 → order_table.id — NOT NULL
- file_name (Field1) — String — NOT NULL
- file_type (Field2) — String — NOT NULL
- file_size (Field3) — Long — NOT NULL
- file_url (Field4) — String — NOT NULL
- thumbnail_url (Field5) — String — NOT NULL
- count (Field6) — Integer — NOT NULL
- ingredient (Field7) — String — NOT NULL
- thickness (Field8) — Double — NOT NULL
acquirer (인수자)
- id (PK) — Long — 기본 키 — NOT NULL
- name (Field1) — String — NOT NULL
- phone (Field2) — String — NOT NULL
- signature_file_name (Field3) — String — NOT NULL
- signature_file_size (Field4) — String — NOT NULL
- signature_file_type (Field5) — String — NOT NULL
- signaure_file_url (Field6) — String — NOT NULL
- created_at (Field7) — String — NOT NULL
comment (댓글)
- id (PK) — Long — 기본 키 — NOT NULL
- order_id (FK1) — Long — 외래 키 → order_table.id — NOT NULL
- user_id (FK2) — Long — 외래 키 → user_table.id — NOT NULL
- content (Field1) — String — NOT NULL
- created_at (Field2) — LocalDate — NOT NULL
customer (고객)
- id (PK) — Long — 기본 키 — NOT NULL
- user_id (FK1) — Long — 외래 키 → user_table.id — NOT NULL
- company_name (Field4) — String
- is_new (Field5) — Boolean — NOT NULL
delivery (납품 정보)
- id (PK) — Long — 기본 키 — NOT NULL
- date (Field1) — LocalDate — NOT NULL
- address (Field2) — String — NOT NULL
- transportation (Field3) — String — NOT NULL
delivery_address (배송지)
- id (PK) — Long — 기본 키 — NOT NULL
- customer_id (FK1) — Long — 외래 키 → customer.id — NOT NULL
- name (Field1) — String — NOT NULL
- zip_code (Field2) — String — NOT NULL
- address (Field3) — String — NOT NULL
- detail_address (Field4) — String
- receiver (Field5) — String — NOT NULL
- phone1 (Field6) — String — NOT NULL
- phone2 (Field7) — String
- is_default (Field8) — Boolean — NOT NULL
factory (공장)
- id (PK) — Long — 기본 키 — NOT NULL
- company_name (Field1) — String — NOT NULL
- representative (Field2) — String — NOT NULL
- fax (Field3) — String
factory_manager (공장 매니저)
- id (PK) — Long — 기본 키 — NOT NULL
- user_id (FK1) — Long — 외래 키 → user_table.id — NOT NULL
- factory_id (FK2) — Long — 외래 키 → factory.id — NOT NULL
ingredient (자재)
- id (PK) — Long — 기본 키 — NOT NULL
- factory_id (FK1) — Long — 외래 키 → factory.id — NOT NULL
- texture (Field1) — String — NOT NULL
- thickness (Field2) — Double — NOT NULL
- width (Field3) — Integer — NOT NULL
- height (Field4) — Integer — NOT NULL
- weight (Field5) — Double — NOT NULL
- created_at (Field6) — LocalDate — NOT NULL
- deleted_at (Field7) — LocalDate
ingredient_price (자재 단가)
- id (PK) — Long — 기본 키 — NOT NULL
- ingredient_id (FK1) — Long — 외래 키 → ingredient.id — NOT NULL
- purchase (Field1) — Integer — NOT NULL
- sell (Field2) — Integer — NOT NULL
- created_at (Field3) — LocalDate — NOT NULL
ingredient_stock (자재 재고)
- id (PK) — Long — 기본 키 — NOT NULL
- ingredient_id (FK1) — Long — 외래 키 → ingredient.id — NOT NULL
- incoming (Field1) — Integer — NOT NULL
- production (Field2) — Integer — NOT NULL
- stock (Field3) — Integer — NOT NULL
- optimal (Field4) — Integer
- created_at (Field5) — LocalDate — NOT NULL
item (품목)
- id (PK) — Long — 기본 키 — NOT NULL
- quotation_id (FK1) — Long — 외래 키 → quotation.id — NOT NULL
- name (Field1) — String — NOT NULL
- material (Field2) — String — NOT NULL
- quantity (Field3) — int — NOT NULL
- processing_cost (Field4) — int
- material_cost (Field5) — int
- bending_cost (Field6) — int
- remark (Field7) — String
order_delivery_address (거래 배송지)
- id (PK) — Long — 기본 키 — NOT NULL
- name (Field1) — String — NOT NULL
- zip_code (Field2) — String — NOT NULL
- address (Field3) — String — NOT NULL
- detail_address (Field4) — String
- receiver (Field5) — String — NOT NULL
- phone1 (Field6) — String — NOT NULL
- phone2 (Field7) — String
order_manufacturing (거래 제조 서비스)
- id (PK) — Long — 기본 키 — NOT NULL
- is_laser_cutting (Field1) — Boolean — NOT NULL
- is_bending (Field2) — Boolean — NOT NULL
- is_welding_fabrication (Field3) — Boolean — NOT NULL
order_post_processing (거래 후처리 서비스)
- id (PK) — Long — 기본 키 — NOT NULL
- is_painting (Field1) — Boolean — NOT NULL
- is_plating (Field2) — Boolean — NOT NULL
order_stage (거래 단계)
- NEW (Field1)
- QUOTE_APPROVAL (Field2)
- IN_PRODUCTION (Field3)
- PRODUCTION_COMPLETED (Field4)
- COMPLETED (Field5)
order_table (거래)
- id (PK) — Long — 기본 키 — NOT NULL
- customer_id (FK1) — Long — 외래 키 → customer.id — NOT NULL
- order_delivery_address_id (FK2) — Long — 외래 키 → order_delivery_address.id — NOT NULL
- order_manufacturing_id (FK3) — Long — 외래 키 → order_manufacturing.id — NOT NULL
- order_post_processing_id (FK4) — Long — 외래 키 → order_post_processing.id — NOT NULL
- quotation_id (FK5) — Long — 외래 키 → quotation_temp.id
- purchase_order_id (FK6) — Long — 외래 키 → purchase_order.id
- acquirer_id (FK7) — Long — 외래 키 → acquirer.id
- name (Field1) — String — NOT NULL
- img_url (Field2) — String — NOT NULL
- stage (Field3) — String — NOT NULL
- request (Field4) — String
- is_urgent (Field5) — Boolean — NOT NULL
- created_at (Field6) — LocalDate — NOT NULL
- completed_at (Field7) — LocalDate
- is_new_issue (Field8) — Boolean — NOT NULL
purchase_order (발주서)
- id (PK) — Long — 기본 키 — NOT NULL
- inspection_period (Field1) — LocalDate — NOT NULL
- inspection_condition (Field2) — String — NOT NULL
- payment_date (Field3) — LocalDate — NOT NULL
- file_name (Field4) — String — NOT NULL
- file_size (Field5) — String — NOT NULL
- file_type (Field6) — String — NOT NULL
- file_url (Field7) — String — NOT NULL
- created_at (Field8) — LocalDate — NOT NULL
quotation (견적서)
- id (PK) — Long — 기본 키 — NOT NULL
- supplier_id (FK2) — Long — 외래 키 → supplier.id — NOT NULL
- delivery_id (FK3) — Long — 외래 키 → delivery.id — NOT NULL
- name (Field1) — String — NOT NULL
- recipient (Field2) — String — NOT NULL
- created_at (Field4) — LocalDate — NOT NULL
- validity_period (Field5) — String — NOT NULL
- total_cost (Field6) — Long — NOT NULL
quotation_temp (임시 견적서)
- id (PK) — Long — 기본 키 — NOT NULL
- total_cost (Field1) — Long — NOT NULL
- file_name (Field2) — String — NOT NULL
- file_size (Field3) — String — NOT NULL
- file_type (Field4) — String — NOT NULL
- file_url (Field5) — String — NOT NULL
- delivery_date (Field6) — LocalDate — NOT NULL
- created_at (Field7) — LocalDate — NOT NULL
supplier (공급자)
- id (PK) — Long — 기본 키 — NOT NULL
- name (Field1) — String — NOT NULL
- representative (Field2) — String — NOT NULL
- address (Field3) — String — NOT NULL
- phone (Field4) — String — NOT NULL
- fax (Field5) — String
- email (Field6) — String — NOT NULL
user_table (사용자)
- id (PK) — Long — 기본 키 — NOT NULL
- email (Field1) — String — NOT NULL
- password (Field2) — String
- name (Field3) — String — NOT NULL
- role (Field4) — String — NOT NULL
- authority (Field5) — String
- phone (Field6) — String — NOT NULL
- zip_code (Field7) — String — NOT NULL
- address (Field8) — String — NOT NULL
- detail_address (Field9) — String
- email_notification (Field10) — Boolean — NOT NULL
- signup_method (Field11) — String — NOT NULL