Table 1Data dictionary

Table nameColumn nameData typeColumn comment
alleleallele_nrintUnique identifier allele instance.
allele_idintIdentifier for each allele.
allele_namevarchar(30)Full allele name defined by IHWG.
allele_shortvarchar(30)Common use allele name.
allele_groupintGroup associated with allele.
compound_nrintNumber identifying to which compound allele is a member.
locus_idintNumber identifying to which locus allele is a member.
activetinyintStatus labeling current active allele for this allele_id.
db_version_nrintIHWG database version to which this allele belongs.
user_idintIdentifier or user who created/updated allele.
user_datedatetimeDate when record was created/updated.
blockblock_nrintUnique identifier for block instance.
block_idintIdentifier for each block.
block_ordintSequence order for each block.
block_typevarchar(1)Defines block type.
locus_idintIdentifier for locus for which block is a member.
ref_posintStart reference position.
ref_lengthintReference length.
working_posintStart working position.
working_lengthintWorking length.
block_namevarchar(20)Common name.
activetinyintStatus of row.
db_version_nrintIHWG database version to which this block belongs.
compoundlocus_idintLocus identifier.
compound_nrintCompound number.
job_transtrans_nrintUnique identifier for transaction.
app_namevarchar(30)Application name that processes transaction.
app_argvarchar(30)Arguments to processing application.
create_datedatetimeTime created.
start_datedatetimeTime application started processing transaction.
end_datedatetimeTime application completed processing transaction.
statusintCurrent status of transaction.
priorityintDefines priority level.
messagevarchar(255)Any message that the processing application wants to record.
kitkit_nrintUnique identifier for kit instance.
kit_idintKit identifier.
kit_local_idintSubmitter identifier.
version_nrintVersion number of kit.
kit_namevarchar(30)Submitter name.
kit_global_idvarchar(30)NCBI-defined name.
kit_batchvarchar(30)Submitter batch.
typeintType.
activetinyintStatus labeling current active kit for this kit_id.
source_idintSource identifier.
user_idintUser identifier.
user_datedatetimeDate created/updated.
kit_locuskit_locus_nrintUnique identifier for kit locus instance.
kit_nrint
kit_idintKit identifier.
locus_idintLocus identifier.
locus_order_nrintOrder for loci to be used.
filter_idintFilter identifier.
tube_idintTube identifier.
tube_order_nrintOrder for tube to be used.
activetinyintStatus labeling current active kit locus for this kit id.
user_idintUser identifier.
user_datedatetimeDate created/updated.
locuslocus_idintIdentifier for locus.
locus_NCBI_idvarchar(30)NCBI locus identifier.
locus_namevarchar(30)Common name.
display_idintIdentifier of allele that should be used as the display reference.
ref_idintIdentifier of reference allele.
locus_MIM_idintMIM locus identifier.
locus_pub_idintPubMed locus identifier.
display_orderintOrder number for display.
mhc_snplocus_idintIdentifier for locus.
ref_posintReference position.
ref_offsetintReference offset.
subsnp_idintdbSNP's ss number.
snp_lengthintSNP's length.
pos_convcompound_nrintCompound number.
working_posintWorking position.
ref_posintReference position.
ref_offsetintReference offset.
blast_posintBLAST position.
probe_workingprobe_working_nrintUnique identifier for each row.
tube_nrintUnique identifier for tube instance.
probe_idintTube (probe) identifier.
user_idintUser identifier.
user_datedatetimeDate created/updated.
activetinyintActive status.
sequencevarchar(255)Working sequence.
sequenceseq_typeintSequence type.
seq_nrintSequence number.
seq_ordintSequence order.
sequencevarchar(255)Character sequence.
sessioncur_session_nrintCurrent session number.
next_session_nrintNext avaliable session number.
user_idintUser identifier.
create_datedatetimeDate created/updated.
sourcesource_nrintUnique identifier source instance.
source_idintSource identifier.
source_codevarchar(3)Source code for use in naming tubes and kits.
institutionvarchar(50)Source name.
admin_idintUser identifier for administrator for source.
addressvarchar(50)Address.
cityvarchar(50)City.
statevarchar(50)State.
postal_codevarchar(20)Postal code.
countryvarchar(50)Country.
phonevarchar(30)Phone number.
faxvarchar(30)Fax number.
emailvarchar(50)Email address.
activetinyintStatus labeling current active source for this source id.
user_idintUser identifier.
user_datedatetimeDate created/updated.
optionsintNot used.
infovarchar(255)Comments/general information.
tubetube_nrintUnique identifier for tube instance.
tube_idintTube identifier.
tube_namevarchar(30)Submitter name.
tube_global_idvarchar(30)NCBI-defined name.
filter_idintFilter identifier.
source_idintSource identifier.
source_datedatetimeNot used.
typeintType.
sensetinyintOrientation.
locus_idintLocus identifier.
ref_posintSubmitted reference position.
ref_offsetintSubmitted reference offset.
stringencyintStringency set for annealing results.
activetinyintStatus labeling current active tube for this tube_id.
user_idintUser identifier.
user_datedatetimeDate created/updated.
recalc_datedatetimeNot used.
db_versionintIHWG database version to which this tube belongs.
infovarchar(255)Comments/general information.
sequencevarchar(255)Submitted sequence.
source_nrint
tube_alleletube_allele_nrintUnique identifier for tube allele instance.
tube_idintTube identifier.
locus_idintLocus identifier.
allele_idintAllele identifier.
user_statusintUser status.
system_statusintSystem status.
ref_posintReference position.
ref_offsetintReference offset.
block_nrintNot used.
scorerealAnnealing score.
working_posintWorking position.
for_tube_idintForward tube identifier.
for_working_posintForward working position.
rev_tube_idintReverse tube identifier.
rev_working_posintReverse working position.
sensetinyintOrientation.
seq_knownintSequence known (sequence fully defined).
activetinyintStatus labeling current active tube allele for this tube_id allele_id combination.
user_idintUser identifier.
user_datedatetimeDate created/updated.
tube_probetube_probe_nrintUnique identifier for tube probe instance.
tube_nrintUnique identifier for tube instance.
probe_idintTube identifier for sub tube in mix.
tube_idintTube identifier.
activetinyintStatus labeling current active tube probe for this tube_id probe_id combination.
usersuser_idintUser identifier.
user_datedatetimeDate created/updated.
user_nrintUnique identifier for user instance.
user_idintUser identifier.
first_namevarchar(30)First name.
last_namevarchar(30)Last name.
loginvarchar(30)Login.
pwdvarchar(30)Password.
source_idintSource identifier.
phonevarchar(30)Phone number.
faxvarchar(30)Fax number.
emailvarchar(50)Email address.
create_probetinyintPermission to create probe.
create_kittinyintPermission to create kit.
modify_probetinyintPermission to modify probe.
modify_reacttinyintPermission to modify reactivity.
modify_kittinyintPermission to modify kit.
infovarchar(255)Comments/general information.
activetinyintStatus labeling current active user for this user_id.
createdby_idintCreated by identifier (another user_id).
created_datedatetimeDate created/updated.
source_admintinyintIs user_id an administrator for source?

From: Chapter 11, The Major Histocompatibility Complex Database, dbMHC

Cover of The NCBI Handbook
The NCBI Handbook [Internet].
McEntyre J, Ostell J, editors.

NCBI Bookshelf. A service of the National Library of Medicine, National Institutes of Health.