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