dream
Tables (4)
Company (업체)
- code (업체코드) — varchar2(10) — Primary key — NOT NULL
- dis_code (구역코드) — varchar2(10) — Primary key — NOT NULL
- name (업체명) — varchar2(20)
- tel (전화번호)
- date (업체등록날짜) — varchar2(20)
- address (주소) — varchar2(20)
- ETC_1 (비고1) — varchar2(20)
- ETC_2 (비고2) — varchar2(20)
- input_date (저장시간) — varchar2(20)
District (구역)
- code (구역코드) — varchar2(10) — Primary key — NOT NULL — 구역테이블 Key
- name (구역이름) — varchar2(20)
- date (등록날짜) — varchar2(14) — YYYYMMDDHH24MISS
- ETC_1 (비고1) — varchar2
- ETC_2 (비고2) — varchar2
- input_date (저장시간) — varchar2(20)
document (서류)
- doc_no (서류번호) — Number — Primary key — NOT NULL
- code (서류코드) — varchar2(20) — Primary key — NOT NULL
- com_code (업체코드) — varchar2(20)
- date (서류날짜) — varchar2(20)
- amount (금액) — number — YYYYMMDD
- tax (세액) — number
- ETC_1 (비고1) — varchar2(20)
- ETC_2 (비고2) — varchar2(20)
- input_date (저장시간) — varchar2(20)
document_info (서류정보)
- doc_no (서류번호) — Number — Primary key — NOT NULL
- doc_code (서류코드) — varchar2(20) — Primary key — NOT NULL
- seq (행번호) — number — Primary key — NOT NULL
- title (헹제목) — varchar2(20)
- standard (규격) — varchar2(20)
- quantity (수량) — varchar2(20)
- price (단가) — number
- supply_price (공급가액) — number
- tax (세액) — number
- remark (비고) — varchar2(20)
- ETC_1 (비고1) — varchar2(20)
- ETC_2 (비고2) — varchar2(20)
- input_date (저장시간) — varchar2(20)