ㅁㄴㅇ

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