SBL_now

Tables (13)

sbl_acrylic_input (아크릴 입고관리)

  • no (아크릴 입고 번호) — 11 — Primary key — NOT NULL
  • order_name (거래처명) — 255 — Foreign key → sbl_order_list.no — NOT NULL
  • in_material_name (자재명) — 255
  • in_standard (자재규격) — 11
  • in_count (수량) — 255

sbl_c_code (공통코드 관리)

  • no (번호) — 11 — Primary key — NOT NULL
  • class (분류) — 255
  • code_name (코드명) — 255
  • code (코드) — 255
  • code_ust (사용여부) — 255

sbl_draft_excel (발주서 상세 관리)

  • no (제품 번호) — 11 — Primary key — NOT NULL
  • draft_no (발주서 번호) — 11 — Foreign key → sbl_order_draft.no — NOT NULL
  • draft_date (발주서 발주일) — 255
  • delivery_date (납품요청일) — 255
  • store_name (매장명) — 255
  • order_text (발주내용) — 255
  • order_store (발주 회사명) — 255
  • delivery_name (납품 업체명) — 255
  • product_name (품명) — 255
  • work_content (작업내용) — 255
  • standard (규격) — 255
  • unit (단위) — 255
  • count (수량) — 255
  • unit_price (단가) — 255
  • price (금액) — 11
  • note (비고) — 255
  • stat (상태) — 255

sbl_materials (원자재 관리)

  • no (번호) — 11 — Primary key — NOT NULL
  • name (자재명) — 255 — Foreign key → sbl_order_materials.no — NOT NULL
  • count (수량) — 11 — Foreign key → sbl_order_materials.order_name — NOT NULL
  • standard (규격) — 255
  • point (단위) — 255
  • feature (특징) — 255
  • order_name (거래처명) — 255

sbl_order_draft (발주서관리)

  • no (번호) — 11 — Primary key — NOT NULL
  • order_name (거래처명) — 255 — Foreign key → sbl_order_list.no — NOT NULL
  • count (당시 재고량) — 11
  • order_count (발주량) — 11
  • point (단위) — 255
  • order_num (발주서번호) — 255
  • order_date (발주일) — 255
  • order_request (납품요청일) — 255

sbl_order_list (거래처관리)

  • no (번호) — 11 — Primary key — NOT NULL
  • order_class (거래처 분류) — 255
  • order_name (거래처명) — 255
  • order_in_charge (담당자) — 255
  • order_contact (연락처) — 255
  • order_adress (주소) — 255

sbl_order_materials (자재발주서관리)

  • no (번호) — 11 — Primary key — NOT NULL
  • order_name (거리처명) — 255 — Foreign key → sbl_order_list.no — NOT NULL
  • name (자재명) — 255 — Foreign key → sbl_materials.name — NOT NULL
  • in_count (수량) — 11 — Foreign key → sbl_materials.count — NOT NULL
  • order_count (발주량) — 11
  • point (단위) — 255
  • order_num (발주번호) — 255
  • regist_date (발주일) — 255
  • order_date (발주요청일) — 255

sbl_out (입고관리)

  • no (번호) — 11 — Primary key — NOT NULL
  • pro_num (생산지시서번호) — 255 — Foreign key → sbl_pro.order_name — NOT NULL
  • out_num (출고지시서번호) — 255
  • out_count (출고수량) — 11
  • out_date (출고지시일) — 255
  • stat (출고상태) — 255

sbl_pro (공정 관리)

  • no (번호) — 11 — Primary key — NOT NULL
  • order_name (발주서번호) — 255 — Foreign key → sbl_order_draft.order_name — NOT NULL
  • pro_name (생산품 명) — 255
  • start_date (생산지시일) — 255
  • pro_count (생산수량) — 11
  • stat (공정 상태) — 255
  • work_content (작업 내용) — 255
  • standard (규격) — 255
  • order_date (작업지시일) — 255
  • start_date (작업시작일) — 255
  • expect_date (작업예상일) — 255
  • shipment_date (출하지시일) — 255
  • n_shipment_sigh_date (미출하등록일) — 255

sbl_pro_materials (공정자재 관리)

  • no (자재선택 번호) — 11 — Primary key — NOT NULL
  • pro_no (지시서 번호) — 11 — Foreign key → sbl_pro.order_name — NOT NULL
  • pro_material (자재명) — 255
  • pro_count (사용수량) — 11
  • stat (상태) — 255

sbl_pro_record (제조이력관리)

  • no (번호) — 11 — Primary key — NOT NULL
  • name (제품명) — 255
  • standard (규격) — 255
  • count (수량) — 11
  • point (단위) — 255
  • date (생산일) — 255

sbl_table (테이블 스타일 관리)

  • no (번호) — 255 — Primary key — NOT NULL
  • style (스타일) — 255
  • ok (사용여부) — 255

sbl_user (계정관리)

  • no (번호) — 11 — Primary key — NOT NULL
  • user_team (소속) — 255
  • user_name (성명) — 255
  • user_id (아이디) — 255
  • user_pw (비밀번호) — 255
  • user_num (연락처) — 255
  • user_power (권한) — 255