TEST
Tables (16)
AcashFix
- SQ_NB — VARCHAR(10) — Primary key — NOT NULL
- DIV_CD — NVARCHAR(8) — Foreign key → Workplace.DIV_CD — NOT NULL
- DEAL_DD — VARCHAR(2)
- RMK_DC — VARCHAR(80)
- CASH_AM — INT
- FR_DT — VARCHAR(8)
- TO_DT — VARCHAR(8)
- PJT_CD — VARCHAR(10)
- DEAL_PD — VARCHAR(255)
- DEAL_MM — VARCHAR(2)
- DISP_SQ — DECIMAL(5,0)
- CASH_CD — NVARCHAR(8) — Foreign key → Acashcd.CASH_CD — NOT NULL
- TR_CD — VARCHAR(10) — Foreign key → Strade.TR_CD
- FTR_CD — VARCHAR(10) — Foreign key → Strade.TR_CD — NOT NULL
Acashcd
- CASH_CD — NVARCHAR(8) — Primary key — NOT NULL
- CO_CD — NVARCHAR(8) — Foreign key → Company.CO_CD — NOT NULL
- CASH_NM — NVARCHAR(20)
- CASH_FG — NVARCHAR(5) — NOT NULL — 수입, 지출
- SUM_CD — NVARCHAR(8)
- SUM_NM — NVARCHAR(20)
- RMK_CD — NVARCHAR(20)
- INSERT_ID — NVARCHAR
- INSERT_DT — NVARCHAR(25)
- MODIFY_ID — NVARCHAR
- MODIFY_DT — NVARCHAR(25)
- TYPE_NM — NVARCHAR(40)
- LEVEL_CD — NVARCHAR(5) — NOT NULL — 1,2,3
- LOW_YN — NVARCHAR(1) — NOT NULL
- USE_YN — NVARCHAR(1) — 0,1
- DISP_SQ — DECIMAL(5, 0)
Change_History
- CH_CD — INT — Primary key — NOT NULL
- EMP_CD — NVARCHAR — Foreign key → Employee.EMP_CD — NOT NULL
- CO_CD — NVARCHAR(8) — Foreign key → Employee.CO_CD — NOT NULL
- CH_CATEGORY — NVARCHAR(10) — 1 = 사원, 2 = 사업장, 3 = 회사
- CH_DT — NVARCHAR(25)
- CH_DIVISION — NVARCHAR(10) — 추가, 수정, 삭제
- CH_IM — NVARCHAR(30)
- CU_IP — NVARCHAR(20)
- CU_NM — NVARCHAR(10)
- CO_NM — NVARCHAR(10)
- CHD_TARGET — NVARCHAR(10) — 변경된 대상
Change_History_Detail
- CHD_CD — INT — Primary key — NOT NULL
- CH_CD — INT — Foreign key → Change_History.CH_CD — NOT NULL
- EMP_CD — NVARCHAR — Foreign key → Change_History.EMP_CD — NOT NULL
- CO_CD — NVARCHAR(8) — Foreign key → Change_History.CO_CD — NOT NULL
- CHD_ITEM — NVARCHAR(30) — 변경된 항목
- CHD_DT — NVARCHAR(20)
- CHD_BT — NVARCHAR(50)
- CHD_AT — NVARCHAR(50)
- CHD_PIC_AT — MEDIUMBLOB
- CHD_PIC_BT — MEDIUMBLOB
Company
- CO_CD — NVARCHAR(8) — Primary key — NOT NULL
- USE_YN — NVARCHAR(1) — 0: 미사용, 1: 사용
- CO_NM — NVARCHAR(30)
- CO_NMK — NVARCHAR(30)
- BUSINESS — NVARCHAR(30)
- JONGMOK — NVARCHAR(30)
- REG_NB — NVARCHAR(30)
- CEO_NM — NVARCHAR(20)
- HO_FAX — NVARCHAR(12)
- CEO_TEL — NVARCHAR(12)
- PPL_NB — NVARCHAR(100)
- HO_ZIP — NVARCHAR(7)
- HO_ADDR — NVARCHAR(150)
- HO_ADDR1 — NVARCHAR(150)
- CO_FG — NVARCHAR(1) — 0: 법인, 1: 사용
- CO_NB — NVARCHAR(30)
- EST_DT — NVARCHAR(8)
- OPEN_DT — NVARCHAR(8)
- CLOSE_DT — NVARCHAR(8)
- PIC_FILE_ID — MEDIUMBLOB
- ACCT_FG — NVARCHAR(4)
Department
- DEPT_CD — VARCHAR(8) — Primary key — NOT NULL
- CO_CD — NVARCHAR(8) — Foreign key → Workplace.CO_CD — NOT NULL
- DIV_CD — NVARCHAR(8) — Foreign key → Workplace.DIV_CD — NOT NULL
- CALL_YN — VARCHAR(10)
- Field2 — VARCHAR(255)
- CALL_NM — VARCHAR(30)
- DEPT_CT — VARCHAR(10)
- DEPT_NM — VARCHAR(30)
- DEPT_NMK — VARCHAR(30)
- APPR_NM — VARCHAR(350)
- MGR_NM — VARCHAR(300)
- DEPT_YN — VARCHAR(1)
- MGR_YN — VARCHAR(1)
- SHOW_YN — VARCHAR(1)
- SORT_YN — VARCHAR(1)
- MDEPT_CD — VARCHAR(8) — Foreign key → Department.DEPT_CD — NOT NULL
Employee
- EMP_CD — NVARCHAR — Primary key — NOT NULL
- CO_CD — NVARCHAR(8) — Foreign key → Company.CO_CD — NOT NULL
- DEPT_CD — VARCHAR(8) — Foreign key → Department.DEPT_CD — NOT NULL
- DIV_CD — NVARCHAR(8) — Foreign key → Department.DIV_CD — NOT NULL
- UESR_YN — NVARCHAR(1) — NOT NULL — ‘0’부, ‘1’ 여
- USE_FG — NVARCHAR — NOT NULL — 0 = 미사용, 1 = 사원 2=관리자
- USERNAME — NVARCHAR
- PASSWORD — NVARCHAR
- KOR_NM — NVARCHAR
- EMAIL_ADD — NVARCHAR
- TEL — NVARCHAR(20)
- GENDER_FG — NVARCHAR — W=여자, M=남자
- JOIN_DT — NVARCHAR(8)
- RTR_DT — NVARCHAR(8)
- PIC_FILE_ID — MEDIUMBLOB
- ENRL_FG — NVARCHAR(3) — 0: 재직, 1:휴직, 2: 퇴사
- PERSONAL_MAIL — NVARCHAR
- PERSONAL_MAIL_CP — NVARCHAR
- SALARY_MAIL — NVARCHAR
- SALARY_MAIL_CP — NVARCHAR
- HOME_TEL — NVARCHAR(20)
- ZIPCODE — NVARCHAR(7)
- ADDR — NVARCHAR(150)
- ADDR_NUM — NVARCHAR(150)
Employee_Roll
- ROLE_NAME — NVARCHAR(30) — Foreign key → Roll.ROLE_NAME — NOT NULL
- EMP_CD — NVARCHAR — Foreign key → Employee.EMP_CD — NOT NULL
- CO_CD — NVARCHAR(8) — NOT NULL
- DIV_CD — NVARCHAR(8) — NOT NULL
- DEPT_CD — VARCHAR(8) — NOT NULL
- USERNAME — NVARCHAR — NOT NULL
- PASSWORD — NVARCHAR — NOT NULL
FINANCECODE
- FINANCE_CD — VARCHAR(3) — Primary key — NOT NULL — 은행코드
- BANK_NAME — VARCHAR(30)
Ftrade
- TR_CD — VARCHAR(10) — Foreign key → Strade.TR_CD — NOT NULL
- CO_CD — VARCHAR(4) — Foreign key → Strade.CO_CD — NOT NULL
- FSTART_DT — VARCHAR(8)
- FEND_DT — VARCHAR(8)
- BA_NB_TR — VARCHAR(80)
- DEPOSITOR — VARCHAR(80)
- DEPOSIT_NM — VARCHAR(80)
- ACCOUNT_OPEN_BN — VARCHAR(80)
- BANK_CD — VARCHAR(3) — Foreign key → FINANCECODE.FINANCE_CD — NOT NULL — 은행코드
Gtrade
- TR_CD — VARCHAR(10) — Foreign key → Strade.TR_CD — NOT NULL
- CO_CD — VARCHAR(4) — Foreign key → Strade.CO_CD — NOT NULL
- REG_NB — VARCHAR(30)
- PPL_NB — VARCHAR(100)
- CEO_NM — VARCHAR
- BUSINESS — VARCHAR(80)
- JONGMOK — VARCHAR(20)
- ZIP — VARCHAR
- ADDR — VARCHAR(150)
- ADDR_NUM — VARCHAR(150)
- PHONE_NB — VARCHAR(20)
- FAX — VARCHAR(20)
- WEBSITE — VARCHAR(30)
- EMAIL — VARCHAR(80)
- START_DT — VARCHAR(16)
- END_DT — VARCHAR(16)
- FOR_YN — VARCHAR(1) — NOT NULL — 0= 내국인, 1=외국인
- LIQ_CD — VARCHAR(1) — Foreign key → LIQUORCODE.LIQ_CD
LIQUORCODE
- LIQ_CD — VARCHAR(1) — Primary key — NOT NULL
- WHOLESALE — VARCHAR(60)
- RETAIL — VARCHAR
Roll
- ROLE_NAME — NVARCHAR(30) — Primary key — NOT NULL
Strade
- TR_CD — VARCHAR(10) — Primary key — NOT NULL
- CO_CD — VARCHAR(4) — Foreign key → Company.CO_CD — NOT NULL
- TR_NM — VARCHAR(60)
- TR_FG — VARCHAR — 1= 일반거래처, 3 =금융거래처
- USE_YN — VARCHAR(1) — NOT NULL — 0= 부, 1= 여
- VIEW_YN — VARCHAR(1) — NOT NULL — 0= 부, 1= 여
StradeRollManage
- TRMG_SQ — INTEGER(30) — Primary key — NOT NULL
- TR_CD — VARCHAR(10) — Foreign key → Strade.TR_CD — NOT NULL
- CO_CD — VARCHAR(4) — Foreign key → Strade.CO_CD — NOT NULL
- DEPT_CD — VARCHAR(8) — Foreign key → Department.DEPT_CD — NOT NULL
- DEPT_NM — VARCHAR(30)
- EMP_CD — VARCHAR(15) — Foreign key → Employee.EMP_CD — NOT NULL
- KOR_NM — VARCHAR(60)
- MANAGE_JOB — VARCHAR(60)
- PHONE_NB — VARCHAR(20)
- EXT_NB — VARCHAR(20)
- MOBILE_NB — VARCHAR(20)
- MAIL_ADDR — VARCHAR(80)
- MANAGE_CG — VARCHAR(1) — 1=정, 2=부
- JOB_GRADE — VARCHAR(15)
- NOTE — VARCHAR(80)
- USE_YN — VARCHAR(1) — NOT NULL — 0= 부, 1= 여
- INSERT_DT — DATE
- ROLL_FG — VARCHAR(1) — NOT NULL — 1=부서, 2=사용자
Workplace
- DIV_CD — NVARCHAR(8) — Primary key — NOT NULL
- CO_CD — NVARCHAR(8) — Foreign key → Company.CO_CD — NOT NULL
- DIV_YN — NVARCHAR(1)
- FILL_YN — NVARCHAR(1) — 0.부, 1.여
- DIV_NM — NVARCHAR(30)
- DIV_ADDR — NVARCHAR(150)
- DIV_TEL — NVARCHAR(12)
- REG_NB — NVARCHAR(30)
- DIV_TO_CD — NVARCHAR(3)
- DIV_NMK — NVARCHAR(30)
- BUSINESS — NVARCHAR(30)
- JONGMOK — NVARCHAR(30)
- OPEN_DT — NVARCHAR(8)
- CLOSE_DT — NVARCHAR(8)
- MAS_NM — NVARCHAR(30)
- DIV_FAX — NVARCHAR(30)
- COP_NM — NVARCHAR(30)