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