itme

Tables (4)

account

  • uid — INT(11) — Primary key — NOT NULL — 고유번호
  • classify — INT(11) — NOT NULL — 거래처구분
  • outsourcing — CHAR(1) — NOT NULL — 외주업체여부' COLLATE 'utf8_general_ci
  • account_cd — VARCHAR(50) — NOT NULL — 거래처코드' COLLATE 'utf8_general_ci
  • account_nm — VARCHAR(50) — NOT NULL — 거래처명' COLLATE 'utf8_general_ci
  • owner — VARCHAR(20) — NOT NULL — 대표자명' COLLATE 'utf8_general_ci
  • owner_mobile — VARCHAR(15) — 대표자휴대폰' COLLATE 'utf8_general_ci
  • corp_no — VARCHAR(15) — 법인등록번호' COLLATE 'utf8_general_ci
  • corp_reg_no — VARCHAR(20) — 사업자등록번호' COLLATE 'utf8_general_ci
  • corp_condition — VARCHAR(50) — 업태' COLLATE 'utf8_general_ci
  • corp_event — VARCHAR(50) — 종목' COLLATE 'utf8_general_ci
  • corp_phone — VARCHAR(15) — 회사전화' COLLATE 'utf8_general_ci
  • corp_fax — VARCHAR(15) — 회사팩스' COLLATE 'utf8_general_ci
  • corp_email — VARCHAR(100) — 회사이메일' COLLATE 'utf8_general_ci
  • corp_zipcode — VARCHAR(10) — 우편번호' COLLATE 'utf8_general_ci
  • corp_address — VARCHAR(255) — 주소' COLLATE 'utf8_general_ci
  • manager — VARCHAR(20) — 담당자' COLLATE 'utf8_general_ci
  • manager_email — VARCHAR(20) — 담당자 이메일' COLLATE 'utf8_general_ci
  • manager_phone — VARCHAR(20) — 담당자 연락처' COLLATE 'utf8_general_ci
  • bank — VARCHAR(20) — 은행' COLLATE 'utf8_general_ci
  • account — VARCHAR(20) — 계좌' COLLATE 'utf8_general_ci
  • account_holder — VARCHAR(20) — 예금주' COLLATE 'utf8_general_ci
  • account_id — VARCHAR(20) — 거래처아이디' COLLATE 'utf8_general_ci
  • account_pwd — VARCHAR(20) — 거래처비밀번호' COLLATE 'utf8_general_ci
  • outsourcing_type — TINYINT(4) — 외주업체유형
  • transaction_status — VARCHAR(20)
  • discount_rate — FLOAT
  • status — CHAR(1) — 상태 (Y/N)' COLLATE 'utf8_general_ci
  • INDEX — `AC_CLASS`

item

  • uid — INT(11) — Primary key — NOT NULL — 유니크아이디
  • classify — INT(11) — 품목구분
  • process_group_uid — INT(11) — item_process_temp_moldtype uid
  • group_cd — INT(11) — 품목그룹
  • item_cd — VARCHAR(50) — 품번' COLLATE 'utf8_general_ci
  • item_nm — VARCHAR(50) — 품명' COLLATE 'utf8_general_ci
  • standard — VARCHAR(50) — 규격' COLLATE 'utf8_general_ci
  • unit — VARCHAR(50) — 단위' COLLATE 'utf8_general_ci
  • packing — VARCHAR(50) — 용기' COLLATE 'utf8_general_ci
  • packing_cnt — SMALLINT(6) — 포장수량
  • delivery_period — INT(11) — 공수기간
  • sales_price — DOUBLE — 판매단가
  • account_cd — VARCHAR(225) — 구매거래처 코드' COLLATE 'utf8_general_ci
  • account_nm — VARCHAR(225) — 구매거래처명' COLLATE 'utf8_general_ci
  • purchase_price — DOUBLE — 구매가격
  • safety_stock_cnt — DOUBLE — 안전재고수량
  • img — VARCHAR(255) — 제품 이미지' COLLATE 'utf8_general_ci
  • img2 — VARCHAR(255) — 도면 이미지' COLLATE 'utf8_general_ci
  • status — CHAR(1) — 상태 (Y/N)' COLLATE 'utf8_general_ci
  • output_cnt — INT(11) — 품목별 시간당생산량
  • op05 — INT(11) — 금형 1
  • op10 — INT(11) — 금형 2
  • INDEX — `classify`
  • INDEX — `group`
  • INDEX — `item_nm`
  • INDEX — `safety_stock_cnt`
  • INDEX — `uid`
  • INDEX — `item_cd`

item_classify

  • uid — INT(11) — Primary key — NOT NULL — 유니크아이디
  • classify_nm — VARCHAR(50) — 품목구분명' COLLATE 'utf8_general_ci
  • classify_char — CHAR(1) — 품목구분문자' COLLATE 'utf8_general_ci
  • seq — INT(11) — 출력순서
  • status — CHAR(1) — 상태 (Y/N)' COLLATE 'utf8_general_ci

item_group

  • uid — INT(11) — Primary key — NOT NULL — 유니크아이디
  • group_nm — VARCHAR(50) — 그룹명' COLLATE 'utf8_general_ci
  • seq — INT(11) — 출력순서
  • status — CHAR(1) — 상태 (Y/N)' COLLATE 'utf8_general_ci