===== Entitní třída D4skse ===== ==== Seznam polí ==== ^Pole ^SQL ^Typ ^Popis ^ |idpk |idpk |Long(18) |ID záznamu | |o0ciselnikBySchedule |[[fk_d4skse_o0ciselnikbyschedule|schedule]] |[[o0ciselnik|O0ciselnik]] | | |d4skseo |[[fk_d4skse_d4skseo|organizer_id]] |[[d4skseo|D4skseo]] | | |o0ciselnikByRegion |[[fk_d4skse_o0ciselnikbyregion|region]] |[[o0ciselnik|O0ciselnik]] | | |o0ciselnikByCountry |[[fk_d4skse_o0ciselnikbycountry|country]] |[[o0ciselnik|O0ciselnik]] | | |o0ciselnikByLanguage |[[fk_d4skse_o0ciselnikbylanguage|language]] |[[o0ciselnik|O0ciselnik]] | | |idVety |id_vety |Long(18) | | |name |name |String(250) | | |code |code |String(50) | | |purpose |purpose |String | | |targetGroup |target_group |String | | |web |web |String(2000) | | |orderLink |order_link |String(250) | | |infoLink |info_link |String(250) | | |city |city |String(100) | | |address |address |String(250) | | |postcode |postcode |String(15) | | |currency |currency |String(3) | | |dph |dph |Integer(9) | | |price |price |Double(53) | | |priceDescription |price_description |String(250) | | |contactPerson |contact_person |String(250) | | |contactPhone |contact_phone |String(30) | | |contactMobil |contact_mobil |String(30) | | |contactFax |contact_fax |String(30) | | |contactEmail |contact_email |String(100) | | |tailorMade |tailor_made |Boolean(1) | | |tailorMadeRange |tailor_made_range |Integer(9) | | |tailorMadeRangeType |tailor_made_range_type |String(250) | | |esf |esf |Boolean(1) | | |discount |discount |Integer(9) | | |translationDetails |translation_details |String(250) | | |professionalGuarantee |professional_guarantee |String(250) | | |obsah |obsah |String | | |prvek |prvek |String(10) | | |elearning |elearning |Boolean(1) | | |publicCourse |public_course |Boolean(1) | | |terms |terms |Date(23) | | |termsAreModuls |terms_are_moduls |Boolean(1) | | |requalification |requalification |Boolean(1) | | |withStay |with_stay |Boolean(1) | | |withWorkPermit |with_work_permit |Boolean(1) | | |conditions |conditions |String | | |certificate |certificate |String(250) | | |lecturer |lecturer |String(250) | | |poPriznak |po_priznak |Character(1) |Příznak pořízení záznamu | |poDatum |po_datum |Date(23) |Datum a čas pořízení záznamu | |zmPriznak |zm_priznak |Character(1) |Příznak poslední změny záznamu | |zmDatum |zm_datum |Date(23) |Datum a čas poslední změny záznamu | |zmPocet |zm_pocet |Integer(9) |Počet změn záznamu |