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