ㅁㄴㅇ
Tables (8)
company_info
- company_id — int(11) — Primary key — NOT NULL
- company_number — varchar(50) — NOT NULL — 사업자등록번호
- company_email — varchar(100) — NOT NULL
- company_address — varchar(255) — NOT NULL
- representative — varchar(50) — NOT NULL — 대표자명
- registration_date — date — NOT NULL — 등록일자
- remarks — text
- company_name (project_code) — varchar(50) — Foreign key → project_master.project_code — NOT NULL
project_master
- project_code — varchar(50) — Primary key — NOT NULL
- project_name — varchar(100) — NOT NULL
- company_name — varchar(100) — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- remarks — text
rack_inout_history
- id — int(11) — Primary key — NOT NULL
- inout_type — enum('IN','OUT') — NOT NULL
- product_id — int(11) — Foreign key → rack_product.product_id — NOT NULL
- product_name — varchar(255) — NOT NULL
- model_name — varchar(255) — NOT NULL
- product_location — varchar(255)
- quantity — int(11) — NOT NULL
- unit_price — decimal(10,0)
- unit_type — varchar(50) — NOT NULL
- User_Name — varchar(255) — NOT NULL
- date — datetime — NOT NULL
- remarks — text
- project_code — varchar(50) — Foreign key → project_master.project_code
rack_product
- product_id — int(11) — Primary key — NOT NULL
- product_name — varchar(255) — NOT NULL
- model_name — varchar(255) — NOT NULL
- Remarks — text
- Created_At — timestamp
- quantity — int(11) — NOT NULL
rack_project_product
- id — int(11) — Primary key — NOT NULL
- product_id — int(11) — Foreign key → rack_product.product_id — NOT NULL
- project_code — varchar(50) — Foreign key → project_master.project_code — NOT NULL
- quantity — int(11)
rack_qr_codes
- qr_id — int(11) — Primary key — NOT NULL
- qr_code — varchar(255) — NOT NULL — QR 코드 이미지 경로 또는 UUID
- qr_data — text — NOT NULL — QR에 저장된 원본 데이터
- generated_at — timestamp — NOT NULL
- is_used — tinyint(1) — NOT NULL — 0:미사용, 1:사용중
- used_at — timestamp
- product_id (product_id2) — int(11) — Foreign key → rack_product.product_id — NOT NULL
rack_tables
- rack_id — int(11) — Primary key — NOT NULL
- rack_position — int(11) — NOT NULL
- rack_no — int(11) — NOT NULL
- rack_level — int(11) — NOT NULL
- rack_layer — int(11) — NOT NULL
- product_id — int(11) — Foreign key → rack_product.product_id
rack_user
- id — int(11) — Primary key — NOT NULL
- Member_id — varchar(50) — NOT NULL
- Member_password — varchar(255) — NOT NULL
- Name — varchar(100) — NOT NULL
- Job_Title — varchar(100)
- Phone_Number — varchar(20)
- Permission — int(11) — NOT NULL