insa
Tables (19)
dbo.INSA_AVGnSTDEV
- RATEYM — varchar(20) — Primary key — NOT NULL
- DIVISIONCD — char(3) — Primary key — NOT NULL
- CENTERCD — char(3) — Primary key — NOT NULL
- TEAMCD — char(3) — Primary key — NOT NULL
- SAVG — varchar(20)
- CENAVG — varchar(20)
- BAVG — varchar(20)
- SASTDEV — varchar(20)
- CENSTDEV — varchar(20)
- BUSTDEV — varchar(20)
- WORKID — varchar(20)
- WORKILSI — varchar(20)
- DIVISIONCD (DIVISIONCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- CENTERCD (CENTERCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- TEAMCD (TEAMCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_BAEBU
- RATEYM — varchar(20) — Primary key — NOT NULL
- SEQNO — int — Primary key — NOT NULL
- MOJIPNM — varchar(50)
- DIVISNCD2 — char(3)
- CENTERCD2 — char(3)
- MOJIPD — varchar(20)
- SPECIA — varchar(20)
- EXCELL — varchar(20)
- AVERAG — varchar(20)
- LACK — varchar(20)
- WORKID — varchar(20)
- WORKILSI — datetime
- AVERAG_PLUS — varchar(20)
- AVERAG_MINUS — varchar(20)
- MORE_LACK — varchar(20)
- BAD — varchar(20)
- DIVISNCD — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- CENTERCD — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_CODE
- CODEID — char(3) — Primary key — NOT NULL
- CODEGRID — char(3) — Primary key — NOT NULL
- DESCRIPTION — char(100)
- IN_TIME — datetime — NOT NULL
- UP_TIME — datetime
- USE_YN — bit — NOT NULL
- CODENAME — varchar(50) — NOT NULL
- CODEORDER — int
- CODEID (GRCODE) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_EMP
- USERNO — char(10) — Primary key — NOT NULL
- USERNAME — varchar(50) — NOT NULL
- GRCODE — varchar(20)
- JICKGUP — char(3)
- JICKCHEAK — char(3)
- STARTDATE — char(8) — NOT NULL
- ENDDATE — char(8)
- AUTHCD — char(3)
- GT_YN — char(1)
- IN_TIME — datetime — NOT NULL
- UP_TIME — datetime
- PASSWD — varbinary(128) — NOT NULL
- CHG_TIME — datetime — NOT NULL
- tel — varchar(15)
- PHOTO_SAVE_DATE — datetime
- HOBONG — varchar(10)
- GRCODE (GRCODE2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_EMP_HIST
- USERNO — char(10) — Primary key — NOT NULL
- SEQNO — bigint — Primary key — NOT NULL
- ISSUETYPE — char(3)
- ISSUEDATE — char(8) — NOT NULL
- GRCODE — char(3)
- JICKGUP — char(3)
- JICKCHEAK — char(3)
- HIRETYPE — char(3)
- IN_TIME — datetime — NOT NULL
- UP_TIME — datetime
- PS_USERNO — char(10)
- GRCODE (GRCODE2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_EMP_HST
- HSTDATE — char(8) — Primary key — NOT NULL
- USERNO — char(10) — Primary key — NOT NULL
- USERNAME — varchar(50) — NOT NULL
- GRCODE — varchar(20)
- JICKGUP — char(3)
- JICKCHEAK — char(3)
- STARTDATE — char(8) — NOT NULL
- ENDDATE — char(8)
- AUTHCD — char(3)
- GT_YN — char(1)
- IN_TIME — datetime — NOT NULL
- UP_TIME — datetime
- PASSWD — varbinary(128)
- GRCODE (GRCODE2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_EMP_RT
- RATEYM — varchar(20) — Primary key — NOT NULL
- USERNO — char(10) — Primary key — NOT NULL
- GRCODE (GRCODE2) — char(3) — NOT NULL
- DIVISNCD (DIVISNCD2) — char(3) — NOT NULL
- CENTERCD (CENTERCD2) — char(3)
- TEAMCD (TEAMCD2) — char(3)
- GNAME — varchar(20) — NOT NULL
- SAWONGB — varchar(20)
- JICKGUP — varchar(20)
- JICKCHAECK — varchar(20)
- IPSAIL — varchar(20)
- EXCUTIVEYN — int
- GAJUNGCHICODE — char(3)
- FSTYN — int
- SNDYN — int
- THRDYN — int
- DEFYN — int
- MOJIPDAN — varchar(20)
- RATEGRADE — varchar(20)
- FIRSTRATE — varchar(20)
- SECONDRATE — varchar(20)
- THIRDRATE — varchar(20)
- DEFINE — varchar(20)
- WORKID — varchar(20)
- WORKILSI — datetime
- JUMINNO — varbinary(128)
- leaveYn — tinyint
- GRCODE — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- DIVISNCD — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- CENTERCD — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- GRCODE (TEAMCD) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_EMP_RT_TEST
- RATEYM — varchar(20) — NOT NULL
- USERNO — char(10) — NOT NULL
- GRCODE — char(3) — NOT NULL
- DIVISNCD — char(3) — NOT NULL
- CENTERCD — char(3)
- TEAMCD — char(3)
- GNAME — varchar(20) — NOT NULL
- SAWONGB — varchar(20)
- JICKGUP — varchar(20)
- JICKCHAECK — varchar(20)
- IPSAIL — varchar(20)
- RTSTATE — char(3) — NOT NULL
- GAJUNGCHICODE — char(3)
- FSTYN — varchar(20)
- SNDYN — varchar(20)
- THRDYN — varchar(20)
- DEFYN — varchar(20)
- MOJIPDAN — varchar(20)
- RATEGRADE — varchar(20)
- FIRSTRATE — varchar(20)
- SECONDRATE — varchar(20)
- THIRDRATE — varchar(20)
- DEFINE — varchar(20)
- WORKID — varchar(20)
- WORKILSI — varchar(20)
- JUMINNO — varbinary(128)
dbo.INSA_GROUP
- GRCODE — char(3) — Primary key — NOT NULL
- GRTYPE — char(3) — NOT NULL
- SUPGR — char(3)
- GRNAME — varchar(50) — NOT NULL
- DEGREE — char(1) — NOT NULL
- USE_YN — char(1) — NOT NULL
- IN_TIME — datetime — NOT NULL
- UP_TIME — datetime
dbo.INSA_GROUP_HST
- HSTDATE — char(8) — Primary key — NOT NULL
- GRCODE — char(3) — Primary key — NOT NULL
- GRTYPE — char(3) — NOT NULL
- SUPGR — char(3)
- GRNAME — varchar(50) — NOT NULL
- DEGREE — char(1) — NOT NULL
- USE_YN — char(1) — NOT NULL
- IN_TIME — datetime — NOT NULL
- UP_TIME — datetime
- GRCODE (GRCODE2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_GROUP_RT
- RATEYM — varchar(20) — Primary key — NOT NULL
- GRCODE (GRCODE2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- GRTYPE — char(3) — NOT NULL
- SUPGR — char(3)
- GRNAME — varchar(20) — NOT NULL
- DEGREE — char(1) — NOT NULL
- USE_YN — char(1) — NOT NULL
- IN_TIME — datetime — NOT NULL
- UP_TIME — datetime
dbo.INSA_INDISCORE
- RATEYM — varchar(20) — Primary key — NOT NULL
- DIVISIONCD — char(3) — Primary key — NOT NULL
- USERNO — char(10) — Primary key — NOT NULL
- GRCODE — char(3)
- CENTERCD — char(3)
- TEAMCD — char(3)
- MODFACTOR — varchar(20)
- SCORE — varchar(20)
- MODSCORE — varchar(20)
- EDURATE — varchar(2)
- WORKID — varchar(20)
- WORKILSI — varchar(20)
- FINAL_SCORE — decimal(4,1)
- FIRST_SCORE — decimal(4,1)
- FIRST_CONVERT_SCORE — decimal(4,1)
- SECOND_SCORE — decimal(4,1)
- SECOND_CONVERT_SCORE — decimal(4,1)
- MULTI_SCORE — decimal(4,1)
- MULTI_CONVERT_SCORE — decimal(4,1)
- GRCODE (GRCODE2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- CENTERCD (CENTERCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- TEAMCD (TEAMCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_ISSUE
- INFOCODE — char(3)
- SEQNO — bigint — NOT NULL
- ISSUEINFO — varchar(100)
- CURINFO — varchar(50)
- FUTUINFO — varchar(50)
- ISSUEDATE — datetime — NOT NULL
- ISSUERESULT — char(3) — NOT NULL
- IN_TIME — datetime — NOT NULL
- UP_TIME — datetime
- USERNO — char(10) — NOT NULL
- issuetype — char(3) — NOT NULL
- memo — varchar(100)
- GRCODE (REF_CURINFO) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- GRCODE (REF_FUTUINFO) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_MODFACTOR
- RATEYM — varchar(20) — Primary key — NOT NULL
- DIVISIONCD — char(3) — Primary key — NOT NULL
- CENTERCD — char(3) — Primary key — NOT NULL
- TEAMCD — char(3) — Primary key — NOT NULL
- MODFACTOR — varchar(20)
- WORKID — varchar(20)
- WORKILSI — varchar(20)
- DIVISIONCD (DIVISIONCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- CENTERCD (CENTERCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- TEAMCD (TEAMCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_RATESHT
- RATEYM — varchar(20) — Primary key — NOT NULL
- USERNO — char(10) — Primary key — NOT NULL
- RATEGB — varchar(50) — Primary key — NOT NULL
- RUSERNO — varchar(10) — Primary key — NOT NULL
- DIVISIONCD — char(3)
- CENTERCD — char(3)
- TEAMCD — char(3)
- JHCD — varchar(20) — NOT NULL
- RATEGRAD — varchar(20) — NOT NULL
- MOJIPDAN — varchar(20) — NOT NULL
- IR01 — varchar(20)
- IR02 — varchar(20)
- IR03 — varchar(20)
- IR04 — varchar(20)
- IR05 — varchar(20)
- IR06 — varchar(20)
- IR07 — varchar(20)
- IR08 — varchar(20)
- IR09 — varchar(20)
- IR10 — varchar(20)
- IR11 — varchar(20)
- IR12 — varchar(20)
- IR13 — varchar(20)
- IR14 — varchar(20)
- IR15 — varchar(20)
- IR16 — varchar(20)
- IR17 — varchar(20)
- IR18 — varchar(20)
- IR19 — varchar(20)
- FSTXT — varchar(MAX)
- SDTXT — varchar(MAX)
- THTXT — varchar(1000)
- WORKID — varchar(20)
- WORKILSI — varchar(20)
- GRADE — varchar(10)
- DIVISIONCD (DIVISIONCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- CENTERCD (CENTERCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- TEAMCD (TEAMCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_RATE_CONFIRM
- RATEYM — varchar(20) — NOT NULL
- USERNO — char(10) — NOT NULL
- DIVISNCD — char(3)
- CENTERCD — char(3)
- TEAMCD — char(3)
- DIVISION — varchar(50)
- CENTER — varchar(50)
- TEAM — varchar(50)
- GRCODE — char(3)
- GNAME — varchar(50)
- JICKCHAECK — char(3)
- JICKGUPNM — varchar(30)
- JICKGUP — char(3)
- GAJUNGCHICODE — char(3)
- MOJIPDAN — char(3)
- DEFINE — char(10)
- FSTRTSCORE — varchar(30)
- SNDRTSCORE — varchar(30)
- MULTIRATE — varchar(30)
- CIBERSCORE — char(2)
- SUMSCORE — varchar(5)
- RTGRADE — char(1)
- MODSCORE — varchar(5)
- DIVISNCD (DIVISNCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- CENTERCD (CENTERCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- TEAMCD (TEAMCD2) — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
dbo.INSA_SELFRATE
- DIVISIONCD — char(3) — Primary key — NOT NULL
- RATEYM — varchar(20) — Primary key — NOT NULL
- USERNO — char(10) — Primary key — NOT NULL
- CENTERCD — varchar(3)
- TEAMCD — varchar(3) — NOT NULL
- RUSERNO — varchar(20)
- JHCD — varchar(20)
- RATEGRAD — varchar(20)
- MOJIPDAN — varchar(20)
- SR001 — varchar(20)
- SR002 — varchar(20)
- SR003 — varchar(20)
- SR004 — varchar(20)
- SR005 — varchar(20)
- SR006 — varchar(20)
- SR007 — varchar(20)
- SR008 — varchar(20)
- SR009 — varchar(20)
- SR010 — varchar(20)
- SR011 — varchar(20)
- SR012 — varchar(20)
- SR013 — varchar(20)
- SR014 — varchar(20)
- SR015 — varchar(MAX)
- SR016 — varchar(MAX)
- SR017 — varchar(MAX)
- SR018 — varchar(800)
- SR019 — varchar(MAX)
- SR020 — varchar(800)
- SR021 — varchar(MAX)
- SR022 — varchar(800)
- SR023 — varchar(800)
- SR024 — varchar(20)
- SR025 — varchar(20)
- SR026 — varchar(800)
- SR027 — varchar(20)
- SR028 — varchar(20)
- SR029 — varchar(20)
- SR030 — varchar(800)
- SR031 — varchar(800)
- SR032 — varchar(20)
- SR033 — varchar(20)
- SR034 — varchar(800)
- SR035 — varchar(20)
- SR036 — varchar(20)
- SR037 — varchar(20)
- SR038 — varchar(800)
- SR039 — varchar(800)
- SR040 — varchar(20)
- SR041 — varchar(20)
- SR042 — varchar(800)
- SR043 — varchar(20)
- SR044 — varchar(20)
- SR045 — varchar(20)
- SR046 — varchar(800)
- SR047 — varchar(800)
- SR048 — varchar(20)
- SR049 — varchar(20)
- SR050 — varchar(800)
- SR053 — varchar(20)
- … +68
dbo.INSA_TEAM_INFO
- GRCODE — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL
- TEAMNAME — varchar(20) — NOT NULL
- OPENDATE — char(10) — NOT NULL
- ENDDATE — char(10)
- CAPTAIN — varchar(30)
- VICECAPTAIN — varchar(30)
- POST1 — char(3)
- POST2 — char(3)
- ADDRESS1 — varchar(100)
- ADDRESS2 — varchar(100)
- PHONE1 — varchar(20)
- PHONE2 — varchar(4)
- PHONE3 — varchar(4)
- FAX1 — char(3)
- FAX2 — varchar(4)
- FAX3 — varchar(20)
- MEMO — varchar(200)
- IN_TIME — datetime — NOT NULL
- UP_TIME — datetime
dbo.convbuseo
- buseo — char(3)
- grcode — char(3)
- grname — varchar(100)
- GRCODE — char(3) — Foreign key → dbo.INSA_GROUP.GRCODE — NOT NULL