Champs disponibles

Designer - Champs disponibles

Avec IDpack, la gestion de base de données se fait automatiquement. Vous n’avez pas besoin de créer ou de gérer vous-même les tables de la base de données. Sélectionnez simplement les champs dont vous avez besoin pour la collecte de données à partir de notre bibliothèque de 132 champs de base de données disponibles. Ces champs peuvent être utilisés dans Designer, Producer, lors des importations, exportations et conceptions de badges. Chaque projet possède ses propres définitions de champs, ce qui vous permet de personnaliser la structure de données selon les besoins de chaque projet.

Vous avez besoin d’un champ qui ne figure pas dans la liste? Demandez un champ personnalisé ici.

Définition des champs (132)

Description du champ	Exemple de contenu du champ	Nom du champ API	Codes abrégés	Type de champ
AC ID	34535	`idc_ac_id`	`[ac_id]`	`varchar(25)`
Access	4 P 2	`idc_access`	`[access]`	`varchar(75)`
Address	5555 Pacific Hill Ave, Los Angeles, CA, 90001	`idc_address`	`[address]`	`varchar(250)`
Age	24	`idc_age`	`[age]`	`decimal(10)`
Allergies	eggs, milk, peanuts	`idc_allergies`	`[allergies]`	`varchar(150)`
Apartment Number	AAF	`idc_apartment_nb`	`[apartment_nb]`	`varchar(150)`
Authorization	R4	`idc_authorization`	`[authorization]`	`varchar(50)`
Batch	BC234ID	`idc_batch`	`[batch]`	`varchar(50)`
Birthdate	1970-25-04	`idc_birthdate`	`[birthdate]`	`date`
Blood Type	A RH NEG	`idc_bloodtype`	`[bloodtype]`	`varchar(25)`
Brand	Brand Name	`idc_brand`	`[brand]`	`varchar(75)`
Card verification value (CVV)	524	`idc_cvv`	`[cvv]`	`int(4)`
Category #1	Color	`idc_category1`	`[category1]`	`varchar(150)`
Category #2	Couleur	`idc_category2`	`[category2]`	`varchar(150)`
Certifying Instructor	John Malcom	`idc_certifying_instructor`	`[certifying_instructor]`	`varchar(150)`
City	Los Angeles	`idc_city1`	`[city1]`	`varchar(150)`
Civic Number	345	`idc_civic_number1`	`[civic_number1]`	`varchar(150)`
Class	A	`idc_class`	`[class]`	`varchar(75)`
Club ID	4581	`idc_club_id`	`[club_id]`	`varchar(150)`
Cost	187.79	`idc_cost`	`[cost]`	`decimal(10.2)`
Country	US	`idc_country1`	`[country1]`	`char(30)`
Country Name	United States	`idc_country_name`	`[country_name]`	`varchar(150)`
Course	One	`idc_course`	`[course]`	`varchar(250)`
Course Date	Jan 17, 2023	`idc_course_date`	`[course_date]`	`date`
Coverage Type	EE	`idc_coverage_type`	`[coverage_type]`	`varchar(75)`
Currency	USD	`idc_currency`	`[currency]`	`varchar(30)`
Current Year	2023	`idc_current_year`	`[current_year]`	`varchar(4)`
Department	Arts	`idc_department`	`[department]`	`varchar(150)`
Depth	1.38	`idc_depth`	`[depth]`	`decimal(10.2)`
Description	3ft x 3ft Natural Oak Extending Dining Table	`idc_description`	`[description]`	`varchar(250)`
Division	Finance	`idc_division`	`[division]`	`varchar(150)`
Driver's license	TS-234-34534-103	`idc_driver`	`[driver]`	`varchar(100)`
Email	[email protected]	`idc_email`	`[email]`	`varchar(150)`
Emergency Contact	Julie Smith, (345) 555-2342	`idc_emergency_contact`	`[emergency_contact]`	`varchar(150)`
Employee ID	1234	`idc_employee_id`	`[employee_id]`	`varchar(150)`
Encryption	WPA	`idc_encryption`	`[encryption]`	`varchar(150)`
Expiration Date	1998-19-02	`idc_expirationdate`	`[expirationdate]`	`date`
Eye color	Brown	`idc_eyecolor`	`[eyecolor]`	`smallint(3)`
Fax Number (Home)	213-555-8317	`idc_homefax`	`[homefax]`	`decimal(15)`
Fax Number (Work)	213-555-5219	`idc_workfax`	`[workfax]`	`decimal(15)`
Feature #1	Oak	`idc_feature1`	`[feature1]`	`varchar(25)`
Feature #2	Rectangle	`idc_feature2`	`[feature2]`	`varchar(25)`
Feature #3	Double Pedestal	`idc_feature3`	`[feature3]`	`varchar(25)`
Feature #4	Butterfly Extensions	`idc_feature4`	`[feature4]`	`varchar(25)`
Feature #5	Wood and Steel	`idc_feature5`	`[feature5]`	`varchar(25)`
First Name	Steve	`idc_firstname`	`[firstname]`	`varchar(150)`
Full Name	Steve Smith	`idc_fullname`	`[fullname]`	`varchar(300)`
Function #1	Journalist	`idc_function1`	`[function1]`	`varchar(75)`
Function #2	Sports	`idc_function2`	`[function2]`	`varchar(75)`
GAMW (Authorizer)	1234567890	`idc_gamw_id_authorizer`	`[gamw_id_authorizer]`	`int(10)`
GAMW #	1234567890	`idc_gamw_id`	`[gamw_id]`	`int(10)`
Gender	Male	`idc_gender`	`[gender]`	`int(1)`
Grade	9th – Freshman	`idc_grade`	`[grade]`	`varchar(75)`
Group	102	`idc_group`	`[group]`	`varchar(25)`
Hair color	Black	`idc_haircolor`	`[haircolor]`	`smallint(3)`
Height	6.05	`idc_height`	`[height]`	`varchar(15)`
Injection 1	08/23/2021	`idc_injection1`	`[injection1]`	`date`
Injection 2	10/23/2021	`idc_injection2`	`[injection2]`	`date`
Issue Date	Sep 04, 2024	`idc_issuedate`	`[issuedate]`	`date`
Language	EN	`idc_language1`	`[language1]`	`varchar(30)`
Last Name	Smith	`idc_lastname`	`[lastname]`	`varchar(150)`
Law 9		`idc_law_9`	`[law_9]`	`varchar(20)`
Length	15.50	`idc_length`	`[length]`	`decimal(10.2)`
Location	BUILDING A	`idc_location`	`[location]`	`varchar(75)`
Medical State	Good	`idc_medical_state`	`[medical_state]`	`varchar(50)`
Medical Status	5	`idc_medical_status`	`[medical_status]`	`varchar(25)`
Member ID	9012	`idc_member_id`	`[member_id]`	`varchar(150)`
MSRP	399.95	`idc_msrp`	`[msrp]`	`decimal(10.2)`
Network Name	SSID	`idc_network_name`	`[network_name]`	`varchar(150)`
Nickname	Maverick	`idc_nickname`	`[nickname]`	`varchar(150)`
Notes	My best friend!	`idc_notes`	`[notes]`	`text(1024)`
Number of Cards	2	`idc_nb_cards`	`[nb_cards]`	`smallint(3)`
Order ID	701-0253509-5186632	`idc_order_id`	`[order_id]`	`varchar(50)`
Organization	ACME Example inc.	`idc_organization`	`[organization]`	`varchar(150)`
Parent's first and last name	John Smith	`idc_parent_fullname`	`[parent_fullname]`	`varchar(250)`
Passport #	VG89103	`idc_passport`	`[passport]`	`varchar(25)`
Password	05#Y6NbBeX&?xl#2	`idc_pw`	`[pw]`	`varchar(150)`
Permit #	DR89823489234-CA	`idc_permit_nb`	`[permit_nb]`	`varchar(150)`
Personal Identification Number (PIN)	4593	`idc_pin_nb`	`[pin_nb]`	`varchar(150)`
Phone Number (Home)	213-555-8317	`idc_homephone`	`[homephone]`	`decimal(15)`
Phone Number (Mobile)	213-555-3453	`idc_mobilephone`	`[mobilephone]`	`decimal(15)`
Phone Number (Work)	213-555-9834	`idc_workphone`	`[workphone]`	`decimal(15)`
PPA Expiration Date	1998-19-02	`idc_expirationdate_ppa`	`[expirationdate_ppa]`	`date`
Price	299.99	`idc_price`	`[price]`	`decimal(10.2)`
Price Type	/each	`idc_pricetype`	`[pricetype]`	`smallint(3)`
Product Name	WOW Dining Table	`idc_productname`	`[productname]`	`varchar(75)`
Pronouns	he/him	`idc_pronouns`	`[pronouns]`	`varchar(40)`
QR code	d174172a-ab34-4e4a-a88b-2076bd6e0db1a19b901b- …	`idc_qrcode`	`[qrcode]`	`text(2048)`
Race/Gender	W/F	`idc_race_gender`	`[race_gender]`	`varchar(50)`
Rank	Chief	`idc_rank`	`[rank]`	`varchar(25)`
Region	Nassau County	`idc_region`	`[region]`	`varchar(150)`
Registration Site	23	`idc_registration_site`	`[registration_site]`	`varchar(25)`
Resident ID	3455467	`idc_resident_id`	`[resident_id]`	`varchar(25)`
Residential District	Venice	`idc_residential_district`	`[residential_district]`	`varchar(150)`
Result	NEGATIVE	`idc_result`	`[result]`	`smallint(3)`
Retraining Date	Jan 17, 2024	`idc_retraining_date`	`[retraining_date]`	`date`
RFID	5737226704	`idc_rfid`	`[rfid]`	`varchar(36)`
RFID Card Type	MIFARE Classic	`idc_rfid_cardtype`	`[rfid_cardtype]`	`varchar(25)`
RFID CSN (Card Serial Number)	7820706	`idc_rfid_csn`	`[rfid_csn]`	`varchar(75)`
RFID JSON	{"type": "MIFARE Classic","csn": "7820706"}	`idc_rfid_json`	`[rfid_json]`	`varchar(512)`
Ship to	Montreal, QC	`idc_ship_to`	`[ship_to]`	`varchar(75)`
Shooting tour		`idc_shooting_tour`	`[shooting_tour]`	`varchar(60)`
SKU	WDT950a	`idc_sku`	`[sku]`	`varchar(25)`
Sport	Open Water Swimming	`idc_sport_en`	`[sport_en]`	`varchar(150)`
Start Date	2021-03-30	`idc_start_date`	`[start_date]`	`date`
State/Province	CA	`idc_state1`	`[state1]`	`varchar(150)`
Status	Active	`idc_status`	`[status]`	`varchar(50)`
Street #1	5555 Pacific Hill Ave	`idc_street11`	`[street11]`	`varchar(150)`
Street #2	Suite #734	`idc_street21`	`[street21]`	`varchar(150)`
Task #1	Greeting	`idc_task1`	`[task1]`	`varchar(50)`
Task #2	Alumni Fair	`idc_task2`	`[task2]`	`varchar(50)`
Team	Amigos	`idc_team_name1`	`[team_name1]`	`varchar(75)`
Test Date	09/28/2021	`idc_test_date`	`[test_date]`	`date`
Test Name	COVID-19	`idc_test_name`	`[test_name]`	`varchar(75)`
Testing Equipment Make	Bobcat	`idc_testing_equipment_make`	`[testing_equipment_make]`	`varchar(150)`
Testing Equipment Model	Compact Track Loaders	`idc_testing_equipment_model`	`[testing_equipment_model]`	`varchar(150)`
Title #1	Chief Executive Officer	`idc_title1`	`[title1]`	`varchar(150)`
Title #2	Chief Technology Officer	`idc_title2`	`[title2]`	`varchar(150)`
Tracking Number	LL 123 2431 34 PC	`idc_tracking_number`	`[tracking_number]`	`varchar(75)`
Type #1	Media	`idc_type1`	`[type1]`	`varchar(75)`
Type #2	Media	`idc_type2`	`[type2]`	`varchar(75)`
Unique URL	https://www.example.com/?id=234234	`idc_url`	`[url]`	`varchar(250)`
UPC	028611000059	`idc_upc`	`[upc]`	`decimal(12)`
Vaccine	COVID-19	`idc_vaccine`	`[vaccine]`	`varchar(50)`
vCard	BEGIN:VCARD ...	`idc_vcard`	`[vcard]`	`text(0)`
VIP	1	`idc_vip`	`[vip]`	`int(1)`
Warehouse	Unit A	`idc_warehouse`	`[warehouse]`	`varchar(75)`
Website	https://www.example.com	`idc_website`	`[website]`	`varchar(250)`
Weight	180.50	`idc_weight`	`[weight]`	`decimal(10.2)`
Width	2.25	`idc_width`	`[width]`	`decimal(10.2)`
ZIP/Postal Code	90001	`idc_zip1`	`[zip1]`	`varchar(15)`
Zone	Area 51	`idc_zone`	`[zone]`	`varchar(75)`