Rack

테이블 (7)

project_master (Untitled7)

  • project_code (Key) — NOT NULL — 기본 키 — NOT NULL
  • project_name (Field) — DATE
  • company_name (Field2) — INT
  • start_date (Field3) — INT
  • end_date (Field4)
  • created_at (Field5)
  • updated_at (Field6)
  • remarks (Field7)

rack_inout_history (CopyOfUntitled7)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • inout_type (Field) — DATE
  • product_id (Field2) — INT
  • product_name (Field3) — INT
  • model_name (Field4)
  • product_location (Field5)
  • quantity (Field6)
  • unit_price (Field7)
  • unit_type (Field8)
  • User_Name (Field9)
  • date (Field10)
  • remarks (Field11)
  • Field12

rack_product (Untitled)

  • product_id (BIGINT UNSIGNED) — NOT NULL — 기본 키 — NOT NULL
  • product_name (Key5) — NOT NULL — 기본 키 — NOT NULL
  • model_name (Field) — VARCHAR
  • Remarks (Field2) — VARCHAR
  • Created_At (Field3)
  • quantity (Field4)

rack_project_product (Untitled11)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • product_id (Field) — NOT NULL
  • quantity (Field2)

rack_tables (Untitled2)

  • rack_id (INT UNSIGNED) — NOT NULL — 기본 키 — NOT NULL
  • rack_position (Field2) — INT
  • rack_no (Field) — INT
  • rack_level (Field3) — VARCHAR
  • rack_layer (Field4) — VARCHAR
  • product_id (Field5) — INT

rack_user (Untitled6)

  • member_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • member_password (Field) — DATE
  • name (Field2) — INT
  • job_title (Field3) — INT
  • phone_number (Field4)
  • permission (Field5)

랙종류 (Untitled3)

  • id (TINYINT UNSIGNED) — NOT NULL — 기본 키 — NOT NULL
  • 재고랙 (Field) — VARCHAR
  • 프로젝트랙 (Field2) — VARCHAR