김천 ARS base
테이블 (16)
BANK
- BCODE — varchar(8)
- BNAME — varchar(50)
CALLDATAS
- SEQ — int — 기본 키 — NOT NULL
- seq — int — 외래 키 → PHONE_CONFIRM_VALUE.seq — NOT NULL
- CID — varchar(44)
- STARTDATE — varchar(8)
- STARTTIME — varchar(6)
- ENDDATE — varchar(8)
- ENDTIME — varchar(6)
- MENU — int — serviceType 1총액 2
- CH — int — 전화걸린 채널
- OFFICENUM — int — 0창원시 1의창구 2성산구 3마산합포구 4마산회원구 5진해구
- ISCONNECTED — int
- NAESUNNUM — varchar(16)
- TAXTYPE — int — 0기본 1체납 2부과 3총금액 4과오납 5미부과 nDamdang
- NAPSEJANO — varchar(24)
- NAPSEJANAME — varchar(100)
- SigunguCode — varchar(16)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CONSULT
- SEQ — int — NOT NULL
- ID — varchar(16)
- CONSULTNAME — varchar(30)
- CATADATE — varchar(8) — test
- CATATIME — varchar(6)
- WORKABLE — int
- PASSWORD — varchar(16)
- JOB — int
- HANDPHONE — varchar(12)
- OFFICENUM — int
- CONSULTTYPE — int
- JOBGROUP — int
- SEMOK — varchar(6)
- NAESUN — varchar(16)
- STATUS — char(1)
- LASTCONDATE — datetime
- SUBJOB — int — NOT NULL
Dam_Status_IN
- seq — int — NOT NULL
- id — varchar(64)
- status_in — varchar(4)
- reg_dt — datetime
- sigungucode — nchar(10)
GWANAP
- GINDEX — int — 기본 키 — NOT NULL
- GNAME — varchar(312)
- GJUMIN — varchar(24)
- GBANK — varchar(3)
- GBANK_NAME — varchar(50)
- GBANK_ACCT — varchar(44)
- GHP — varchar(44)
- GAMOUNT — int
- GISCOMPLETE — int
- GNO — varchar(20)
- OFFICENUM — int
- ID — varchar(20)
- SEMOK_NAME — varchar(200)
- SEMOK_CODE — varchar(20)
- SAYU_NAME — varchar(200)
- SAYU_CODE — varchar(20)
- GREGDATE — datetime
- Scode — varchar(5)
- GSAUPJA — varchar(12)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Gwanap_Day
- GINDEX — int — 외래 키 → GWANAP.GINDEX — NOT NULL
- seq — int — NOT NULL
- SigunguCode — varchar(12)
- Gubun — int
- Reg_date — datetime
HOLIDAY
- seq — int — 기본 키 — NOT NULL
- SEQ — int — 외래 키 → CALLDATAS.SEQ — NOT NULL
- seq (seq2) — int — 외래 키 → CALLDATAS.seq — NOT NULL
- NAME — varchar(50)
- YEAR — int
- MONTH — int
- DAY — int
- EXP — varchar(50)
- SigunguCode — varchar(12)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MANAGER_SEMOK
- seq — int — 기본 키 — NOT NULL
- SemokName — varchar(64)
- SigunguCode — varchar(16)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
PHONE_CONFIRM_VALUE
- seq — int — 기본 키 — NOT NULL
- reg_date — datetime
- filename — varchar(512)
- COMPLETE_VALUE — varchar(2)
- FULL_VALUE — varchar(32)
- Phone_Num — varchar(16)
- Phone_Num_ARIA — varchar(44)
- Napseja_Num — varchar(16)
- Napseja_Num_ARIA — varchar(24)
- Err_Code — varchar(32)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
PutCallInfo
- seq — int — 기본 키 — NOT NULL
- SEQ — int — 외래 키 → CALLDATAS.SEQ — NOT NULL
- seq (seq2) — int — 외래 키 → CALLDATAS.seq — NOT NULL
- Gubun — varchar(20)
- Name — varchar(60)
- Num — varchar(24)
- Tel — varchar(44)
- Cid — varchar(44)
- Reg_DT — datetime
- SigunguCode — varchar(12)
- SigunguName — varchar(32)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SIGUN_INFO
- seq — int — 기본 키 — NOT NULL
- SigunguName — varchar(64)
- SigunguCode — varchar(16)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SemokPoint
- seq — int — 기본 키 — NOT NULL
- SemokName — varchar(50)
- SemokCode — varchar(10)
- semokPoint — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TASKTIME
- SEQ — int — 기본 키 — NOT NULL
- SEQ (SEQ2) — int — 외래 키 → CALLDATAS.SEQ — NOT NULL
- seq — int — 외래 키 → CALLDATAS.seq — NOT NULL
- SYMD — varchar(20)
- EYMD — varchar(20)
- TWORK — varchar(256)
- SigunguCode — varchar(16)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Time_Lunch
- seq — int — NOT NULL
- time_start — varchar(4)
- time_end — varchar(4)
- reg_dt — datetime
- staff_name — varchar(64)
- staff_seq — int
- content — varchar(512)
Time_Work
- seq — int — NOT NULL
- time_start — varchar(4)
- time_end — varchar(4)
- reg_dt — datetime
- staff_name — varchar(64)
- staff_seq — int
- content — varchar(512)
tempstaff
- seq — int — NOT NULL
- num — varchar(16)
- name — varchar(32)
- reg_dt — datetime