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)