hexagon

Tables (14)

Client (거래처)

  • id — number — Primary key — NOT NULL
  • trade_name — varchar2 — NOT NULL
  • ceo_name — varchar2 — NOT NULL
  • business_type — varchar2 — NOT NULL
  • business_event — varchar2 — NOT NULL
  • phone — varchar2 — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

Employee (사원)

  • id — number — Primary key — NOT NULL
  • name — varchar2 — NOT NULL
  • phone — varchar2 — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

Shipment_warehouse (창고)

  • id — number — Primary key — NOT NULL
  • code — varchar2 — NOT NULL
  • name — varchar2 — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

estimate (견적서)

  • id — number — Primary key — NOT NULL
  • employee — number — Foreign key → Employee.id — NOT NULL
  • client — number — Foreign key → Client.id — NOT NULL
  • status — varchar2 — NOT NULL
  • not_order_quantity — number — NOT NULL
  • not_order_supply_price — number — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

estimate_product (견적서_품목)

  • id — number — Primary key — NOT NULL
  • product — number — Foreign key → product.id — NOT NULL
  • estimate — number — Foreign key → estimate.id — NOT NULL
  • quantity — number — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

order_estimate (주문서_견적서)

  • id — number — Primary key — NOT NULL
  • order_sheet — number — Foreign key → order_sheet.id — NOT NULL
  • estimate — number — Foreign key → estimate.id — NOT NULL
  • product — number — Foreign key → product.id — NOT NULL
  • quantity — number — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

order_sale (판매_주문서)

  • id — number — Primary key — NOT NULL
  • order_sheet — number — Foreign key → order_sheet.id — NOT NULL
  • product_sale — number — Foreign key → product_sale.id — NOT NULL
  • product — number — Foreign key → product.id — NOT NULL
  • quantity — number — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

order_sheet (주문서)

  • id — number — Primary key — NOT NULL
  • employee — number — Foreign key → Employee.id — NOT NULL
  • id (id2) — number — Foreign key → Client.id — NOT NULL
  • status — varchar2 — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

product (품목)

  • id — number — Primary key — NOT NULL
  • warehouse — number — Foreign key → Shipment_warehouse.id — NOT NULL
  • name — varchar2 — NOT NULL
  • standard — varchar2 — NOT NULL
  • quantity — number — NOT NULL
  • price — number — NOT NULL
  • supply_price — varchar2 — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

product_sale (판매)

  • id — number — Primary key — NOT NULL
  • employee — number — Foreign key → Employee.id — NOT NULL
  • id (id2) — number — Foreign key → Client.id — NOT NULL
  • type — varchar2 — NOT NULL
  • sale_date — date — NOT NULL
  • created_at — date — NOT NULL
  • updated_atu (updated_at) — date — NOT NULL

sale_si (판매_출하지시서)

  • id — number — Primary key — NOT NULL
  • product_sale — number — Foreign key → product_sale.id — NOT NULL
  • shipping_instruction — number — Foreign key → shipping_instruction.id — NOT NULL
  • product — number — Foreign key → product.id — NOT NULL
  • quantity — number — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

shipping (출하)

  • id — number — Primary key — NOT NULL
  • employee — number — Foreign key → Employee.id — NOT NULL
  • id (id2) — number — Foreign key → Client.id — NOT NULL
  • address — varchar2 — NOT NULL
  • phone — varchar2 — NOT NULL
  • postal_code — varchar2 — NOT NULL

shipping_instruction (출하 지시서)

  • id — number — Primary key — NOT NULL
  • employee — number — Foreign key → Employee.id — NOT NULL
  • id (id2) — number — Foreign key → Client.id — NOT NULL
  • instruction_date — date — NOT NULL
  • status — varchar2 — NOT NULL
  • remarks — varchar2
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

si_shipping (출하_출하지시서)

  • id — number — Primary key — NOT NULL
  • shipping_instruction — number — Foreign key → shipping_instruction.id — NOT NULL
  • shipping — number — Foreign key → shipping.id — NOT NULL
  • product — number — Foreign key → product.id — NOT NULL
  • quantity — number — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL