Tofu - Baza

Create Declare Cursor Hungarian
Select Update Insert Fancy
Tabela		Suffix
Select	All, None, Invert


Naziv	Tip	Null	Privzeto	Opis
anKey	int	0	(0)
acVacancyType	char(1)	1	('D')
acPDRegNo	char(10)	1	('')
acActive	char(1)	1	('T')
acEmployer	char(30)	1	('')
acEmployerAddress	varchar(60)	1	('')
acRegNoPRS	char(13)	1	('')
acActivitySKD	char(6)	1	('')
acAdminUnit	char(30)	1	('')
anNeedWorkers	int	1	(1)
acJob	char(30)	1	('')
acJobDesc	varchar(2000)	1	('')
acJobOccupSKP	char(7)	1	('')
acIGroup	char(1)	1	('1')
acOccup	char(10)	1	('')
acOccupAlt	char(10)	1	('')
acOccupsNPK	char(12)	1	('')
acReqType	char(1)	1	('1')
acEmployment	char(1)	1	('N')
anEmploymentTime	tinyint	1	(0)
acEmplType	char(1)	1	('P')
anEmplTypeHour	tinyint	1	(0)
acFree	char(1)	1	('T')
adFreeUntil	smalldatetime	1	(getdate())
anMinSlry	money	1	(0)
acSlryCurrency	char(3)	1	('')
acSchedule	char(1)	1	('1')
acTrialWork	char(1)	1	('T')
anTrialWorkPeriod	tinyint	1	(0)
acExpirience	char(1)	1	('N')
anExpirienceYr	tinyint	1	(0)
anExpirienceMonth	tinyint	1	(0)
acPhysAbiStrength	char(1)	1	('F')
acPhysAbiManual	char(1)	1	('F')
acPhysAbiSight	char(1)	1	('F')
acOrganisation	char(1)	1	('F')
acCommSkill	char(1)	1	('F')
acManagerSmall	char(1)	1	('F')
acManagerBig	char(1)	1	('F')
acDriverLicenc	char(1)	1	('N')
acDriverLicencA	char(1)	1	('F')
acDriverLicencB	char(1)	1	('F')
acDriverLicencC	char(1)	1	('F')
acDriverLicencD	char(1)	1	('F')
acDriverLicencE	char(1)	1	('F')
acDriverLicencF	char(1)	1	('F')
acDriverLicencG	char(1)	1	('F')
acDriverLicencH	char(1)	1	('F')
acLanguage1	char(30)	1	('')
acLanguage1Degree	char(1)	1	('0')
acLanguage2	char(30)	1	('')
acLanguage2Degree	char(1)	1	('0')
acLanguage3	char(30)	1	('')
acLanguage3Degree	char(1)	1	('0')
acLanguage4	char(30)	1	('')
acLanguage4Degree	char(1)	1	('0')
acCS1Degree	char(1)	1	('0')
acCS2Degree	char(1)	1	('0')
acCS3Degree	char(1)	1	('0')
acCS4Degree	char(1)	1	('0')
acCS5Degree	char(1)	1	('0')
acCS6Degree	char(1)	1	('0')
acCS7Degree	char(1)	1	('0')
acOtherTerms	varchar(2000)	1	('')
acEmploymentCause	char(2)	1	('')
anDeadline	tinyint	1	(7)
adPRIJAVADateIZID	smalldatetime	1
acSpecReq	char(1)	1	(1)
acSpecReqEU	varchar(250)	1	('')
acSpecReqNew	char(1)	1	('1')
acEmplOff	char(1)	1	('1')
anEmplOffAppNo	tinyint	1	(0)
acEmplOffOther	varchar(200)	1	('')
acMedia	char(1)	1	('T')
acContact	char(30)	1	('')
acContact_Phone	char(30)	1	('')
acContact_Email	char(30)	1	('')
acContact2	char(30)	1	('')
acContact2_Phone	char(30)	1	('')
acContact2_Email	char(30)	1	('')
adDateAccepted	smalldatetime	1
adDatePublish	smalldatetime	1
acVacancyNotice	char(1)	1	('O')
anNo	int	1	(0)
anVacation	int	1	(0)
acPOSEBNEZAHT	char(2)	1	('0')
acOccupProgramm	varchar(80)	1	('')
acTransport	char(1)	1	('K')
anMaxSlry	money	1	(0)
acDriverLicenc1	char(1)	1	('')
acDriverLicenc2	char(1)	1	('')
acDriverLicenc3	char(1)	1	('')
acAge	char(1)	1	('V')
anAgeFrom	tinyint	1	(0)
anAgeTo	tinyint	1	(0)
acHousingFamily	char(1)	1	('F')
acHousingGroup	char(1)	1	('F')
acHousingSingle	char(1)	1	('F')
acFood	char(1)	1	('Z')
acLanguage1Code	char(2)	1	('')
acLanguage1Level	char(1)	1	('')
acLanguage2Code	char(2)	1	('')
acLanguage2Level	char(1)	1	('')
acRAC1KODA	char(2)	1	('')
acRAC1NIVO	char(1)	1	('1')
acRAC2KODA	char(2)	1	('')
acRAC2NIVO	char(1)	1	('')
anUserIns	smallint	1
adTimeIns	datetime	1
anUserChg	smallint	1
adTimeChg	datetime	1
adEmploymentDate	smalldatetime	1
acDeadline	char(1)	1	('A')
anDeadlineDays	tinyint	1
acEmplMan	char(1)	1	('1')
acEmplManSubm	char(1)	1	('A')
acInstMedia	char(1)	1	('1')
acEmplSpecIntent	char(1)	1	('1')
acEmplSpecForeign	char(1)	1	('')
acContactOrg	char(1)	1	('1')
acContact2Org	char(1)	1	('1')
acContactAs2	char(1)	1	('1')
acInstInter1	char(1)	1	('F')
acInstInter2	char(1)	1	('F')
anInstInter2Max	smallint	1
acInstInter3	char(1)	1	('F')
acInstInter3Country	varchar(250)	1
acInstInter4	char(1)	1	('F')
acKindOfContract	char(1)	1
anGrossSlry	money	1
acSuitDisab	char(1)	1
acOtherNote	varchar(250)	1
acLang1DegrUnderst	char(1)	1	('')
acLang1DegrSpeech	char(1)	1	('')
acLang1DegrWrite	char(1)	1	('')
acLang2DegrUnderst	char(1)	1	('')
acLang2DegrSpeech	char(1)	1	('')
acLang2DegrWrite	char(1)	1	('')
acLang3DegrUnderst	char(1)	1	('')
acLang3DegrSpeech	char(1)	1	('')
acLang3DegrWrite	char(1)	1	('')
acContactAgency	varchar(250)	1
acContact2Agency	varchar(250)	1

Select All, None, Invert

Uporabniki

Login
Ime
Geslo
Zapomni si me