금오 거래 센터

테이블 (18)

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_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 (FK) — 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

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.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
  • 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

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