newEcholine
Tables (7)
COMPANY_MST
- COMPANY_CODE — nvarchar(20) — Primary key — NOT NULL
- SITE — nvarchar(30) — COMMON_CODE (SITE)
- COMPANY_NAME_LOC — nvarchar(105) — NOT NULL
- COMPANY_NAME_ENG — nvarchar(105)
- SHIPPER_TYPE — nvarchar(10)
- INDUSTRY_TYPE — nvarchar(90)
- BUSINESS_TYPE — nvarchar(90)
- DUNS_NO — nvarchar(20)
- IRS_NO — nvarchar(33)
- REG_NO — nvarchar(48)
- FOUNDATION_DATE — nvarchar(8)
- RESIDENT_NAME — nvarchar(30)
- RESIDENT_NO — nvarchar(20)
- ADDR — nvarchar(105)
- EMAIL — nvarchar(241)
- PHONE_NO — nvarchar(16)
- FAX_NO — nvarchar(30)
- POST_NO — nvarchar(20)
- LANGUAGE — nvarchar(5)
- CUR — nvarchar(15)
- COUNTRY — nvarchar(2)
- CITY_CODE — nvarchar(30)
- CITY_DESC — nvarchar(105)
- ATTACH_NO — nvarchar(20)
- EMAIL_SEND_FLAG — nvarchar(1)
- SMS_SEND_FLAG — nvarchar(1)
- ADD_DATE — nvarchar(8)
- ADD_TIME — nvarchar(6)
- ADD_USER_ID — nvarchar(32)
- CHANGE_DATE — nvarchar(8)
- CHANGE_TIME — nvarchar(6)
- CHANGE_USER_ID — nvarchar(32)
- DEL_FLAG — nvarchar(1)
- COM_DB — nvarchar(50)
- SITE_URL — nvarchar(50)
- SAPUSER — nvarchar(50)
- SAPPW — nvarchar(50)
- SAP_HANA — nvarchar(100)
- COMPANY_MST — nvarchar(50)
- UNIPOSTSITEID — nvarchar(50)
- SBO_SL_URL — nvarchar(500)
- RPANO — int
- REMARKS — nvarchar(500)
- CUSTLOGO — nvarchar(200)
- PCUSTCODE — nvarchar(50)
- CUSTDIV — char(1)
- ACTIVE — char(1) — NOT NULL
- RMONTH — int
- RSTARTDT — date
- RENDDT — date
- REPAIRYN — char(1) — NOT NULL
- SHOWYN — char(1) — NOT NULL
- CONFYN — char(1) — NOT NULL
- TESTYN — char(1) — NOT NULL
- SYSTEMYN — char(1) — NOT NULL
- TARGERYN — char(1) — NOT NULL
- ATCHMNFL_ID — nvarchar(30)
GROUP_MENU
- MENU_CD — nvarchar(35) — Foreign key → MENU_USER.MENU_CD — NOT NULL — MENU_MST.MENU_CD
- GROUP_CD — NVARCHAR(35) — Foreign key → GROUP_MST.GROUP_CD — NOT NULL — GROUP_MST.GROUP_CD
- COMPANY_CODE (COMPANY_CODE2) — nvarchar(20) — Foreign key → GROUP_MST.COMPANY_CODE — NOT NULL
- REG_DT — datetime — NOT NULL
- REG_USR_ID — nvarchar(30) — NOT NULL
- UPT_DT — datetime — NOT NULL
- UPT_USR_ID — nvarchar(30) — NOT NULL
GROUP_MST
- GROUP_CD — NVARCHAR(35) — Primary key — NOT NULL
- COMPANY_CODE — nvarchar(20) — Foreign key → COMPANY_MST.COMPANY_CODE — NOT NULL
- GROUP_NM — NVARCHAR(300)
- GROUP_ADMIN_FLAG — NVARCHAR(1)
- REG_DT — DATETIME — NOT NULL
- USE_SITE — NVARCHAR(30) — COMMON_CODE (SITE), COMPANY_MST .SITE
- REG_USR_ID — NVARCHAR(30) — NOT NULL
- UPT_DT — DATETIME — NOT NULL
- UPT_USR_ID — NVARCHAR(30) — NOT NULL
- Field
GROUP_USER
- GROUP_CD — NVARCHAR(35) — Foreign key → GROUP_MST.GROUP_CD — NOT NULL — GROUP_MST.GROUP_CD
- COMPANY_CODE — nvarchar(20) — Foreign key → GROUP_MST.COMPANY_CODE — NOT NULL
- MBER_ID — nvarchar(30) — Foreign key → MEMBER_MST.MBER_ID — NOT NULL — MEMBER_MST.MBER_ID
- COMP — nvarchar(20) — Foreign key → MEMBER_MST.CORP — NOT NULL — MEMBER_MST.CORP
- REG_DT — DATETIME — NOT NULL
- REG_USR_ID — NVARCHAR(30) — NOT NULL
- UPT_DT — DATETIME — NOT NULL
- UPT_USR_ID — NVARCHAR(30) — NOT NULL
MEMBER_MST
- MBER_ID — nvarchar(30) — Primary key — NOT NULL
- CORP — nvarchar(20) — Foreign key → COMPANY_MST.COMPANY_CODE — NOT NULL — COMPANY_MST.COMPANY_CODE
- COMPANY_CODE — nvarchar(12)
- MBER_NM — nvarchar(300) — NOT NULL
- USER_TYPE — nvarchar(10) — NOT NULL
- SELLER_CODE — nvarchar(30)
- PASSWORD — nvarchar(64)
- PW_CHANGE_DT — datetime2(7)
- TEMP_PW_FG — nchar(1) — NOT NULL
- MOBILE_NO — nvarchar(30)
- TEL_NO — nvarchar(16)
- DEPT — nvarchar(200)
- EMAIL — nvarchar(241)
- FAX_NO — nvarchar(30)
- SlpCode — int
- ERP_USR_ID — nvarchar(30)
- DUTY_CD — nvarchar(27)
- DUTY_NM — nvarchar(200)
- DUTY_E_NM — nvarchar(200)
- TITLE_CD — nvarchar(27)
- TITLE_NM — nvarchar(200)
- TITLE_E_NM — nvarchar(200)
- DEGREE_CD — nvarchar(27)
- DEGREE_NM — nvarchar(200)
- DEGREE_E_NM — nvarchar(200)
- RES_NO — nvarchar(13)
- ATTR1 — nvarchar(50)
- PARTNER_FG — nvarchar(1)
- EX_MAIL — nvarchar(241)
- MBER_NM_ENG — nvarchar(200)
- LNM_KR — nvarchar(100)
- FNM_KR — nvarchar(100)
- LNM_EN — nvarchar(100)
- FNM_EN — nvarchar(100)
- ENT_DATE — nvarchar(10)
- RET_DATE — nvarchar(10)
- PHOTO_URL — nvarchar(600)
- CONECT_DT — datetime
- ADD_DATE — nvarchar(50)
- ADD_TIME — nvarchar(6)
- ADD_USER_ID — nvarchar(32)
- CHANGE_DATE — nvarchar(50)
- CHANGE_TIME — nvarchar(6)
- CHANGE_USER_ID — nvarchar(32)
- DEL_FLAG — nvarchar(1) — NOT NULL
- NEW_YN — nvarchar(1) — NOT NULL
- USE_IP — nvarchar(50)
- LOGOUTYN — nvarchar(1)
- DFLWAREHOUSE — nvarchar(10)
- MENUSTR — nvarchar(4000)
- SNSDT — nvarchar(50)
- SNSCODE — nvarchar(30)
- OcrCode — nvarchar(50)
- BPLId — nvarchar(50)
- USERLEVEL — nvarchar(50)
- UNIPOSTID — nvarchar(30)
- ADMINYN — nvarchar(10)
- UUID — nvarchar(50)
- UUIDYN — nvarchar(1)
- NUMHIDDEN — nvarchar(1)
- … +9
MENU_MST
- MENU_CD — nvarchar(35) — Primary key — NOT NULL
- SITE — nvarchar(300) — COMMON_CODE (SITE)
- MENU_NM — nvarchar(300)
- MENU_URL — nvarchar(100)
- UPPER_MENU_CD — nvarchar(35)
- SORT_ORDR — decimal(10, 0) — NOT NULL
- MENU_SE — nvarchar(35) — NOT NULL
- OUTPT_FG — nchar(1) — NOT NULL
- TMPLAT — nvarchar(100)
- REG_DT — datetime — NOT NULL
- REG_USR_ID — nvarchar(30) — NOT NULL
- UPT_DT — datetime — NOT NULL
- UPT_USR_ID — nvarchar(30) — NOT NULL
- W_ICON — nvarchar(50)
- MOBILE_YN — nvarchar(1)
- LINKSC — nvarchar(50)
- TABLECD — nvarchar(20)
- NAV_HEADER — nvarchar(50)
- REMARK — nvarchar(1000)
MENU_USER
- MENU_CD — nvarchar(35) — Foreign key → MENU_MST.MENU_CD — NOT NULL — MENU_MST.MENU_CD
- COMPANY_CODE — nvarchar(20) — Foreign key → COMPANY_MST.COMPANY_CODE — NOT NULL
- SITE — nvarchar(300) — COMMON_CODE (SITE), COMPANY_MST .SITE
- USEYN — nvarchar(1)
- ARR — int
- EDITYN — nvarchar(1)