scm초안
테이블 (5)
company
- company_code — INT — 기본 키 — NOT NULL
- company_class_name — VARCHAR(10) — NOT NULL
- company_class_code — VARCHAR(50) — NOT NULL
- input_date — VARCHAR(50)
- input_user — VARCHAR(50)
- input_program — VARCHAR(50)
- update_date — VARCHAR(50)
- update_user — VARCHAR(50)
- update_program — VARCHAR(50)
order
- order_code — INT — 기본 키 — NOT NULL
- count — INT
- input_date — DATETIME
- shipment_wish_date — DATE
- input_user — VARCHAR(50)
- input_program — VARCHAR(50)
- update_date — DATETIME
- update_user — VARCHAR(50)
- update_program — VARCHAR(50)
orderlist
- order_detail_code — INT — 기본 키 — NOT NULL
- return_request — VARCHAR(45)
- return_date — DATETIME
- deliver_paper — CHAR
- purchase_paper — CHAR
- return_paper — CHAR
- input_date — DATETIME
- input_program — VARCHAR(50)
- update_date — DATETIME
- update_user — VARCHAR(50)
- update_program — VARCHAR(50)
paper
- paper_code — INT — 기본 키 — NOT NULL
- paper_category_code — INT
- paper_name — VARCHAR(50)
- owner_approve — CHAR
- deposit_check — CHAR — NOT NULL
- input_date — DATETIME
- input_program — VARCHAR(50)
- update_date — DATETIME
- update_user — VARCHAR(50)
- update_program — VARCHAR(50)
user_code
- user_code — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(10) — NOT NULL
- user_password — VARCHAR(100) — NOT NULL
- employee_name — VARCHAR(10) — NOT NULL
- user_type — INT — NOT NULL
- manager_type — VARCHAR(10)
- phone_number — VARCHAR(13) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- user_address — VARCHAR(100) — NOT NULL
- user_address_detail — VARCHAR(100) — NOT NULL
- bank_name — VARCHAR(20)
- account_number — VARCHAR(20)
- account_holder — VARCHAR(20)
- create_date — DATETIME — NOT NULL
- update_date — DATETIME
- update_user — VARCHAR(45)
- update_program — VARCHAR(45)