PRINTS-S Schema





The following tables provide a more detailed description of the attributes in each entity: 
Table    = fingerprint
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| fprint_accn                      | varchar()                        |    15 |
| identifier                       | varchar()                        |    15 |
| motifs                           | int2                             |     2 |
| date                             | date                             |     4 |
| up_date                          | date                             |     4 |
| family_title                     | text                             |   var |
| family_doc                       | varchar()                        |    18 |
| category                         | text                             |   var |
| second_accn                      | varchar()                        |    15 |
| pseudo                           | bool                             |     1 |
+----------------------------------+----------------------------------+-------+  

Table    = motif
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| fprint_accn                      | varchar()                        |    18 |
| motif                            | int2                             |     2 |
| repeat                           | varchar()                        |     4 |
| seqn_accn                        | varchar()                        |    15 |
| seqn_fragment                    | varchar()                        |    35 |
| start_position                   | int4                             |     4 |
| inter_motif_dist                 | int4                             |     4 |
| initial                          | bool                             |     1 |
| final                            | bool                             |     1 |
+----------------------------------+----------------------------------+-------+    

Table    = inter_motif
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| fprint_accn                      | varchar()                        |    15 |
| motif_a                          | int2                             |     2 |
| motif_b                          | int2                             |     2 |
| minimum                          | int4                             |     4 |
| maximum                          | int4                             |     4 |
+----------------------------------+----------------------------------+-------+

Table    = seqn
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| seqn_accn                        | varchar()                        |    15 |
| seqn_id                          | varchar()                        |    15 |
| seqn_title                       | text                             |   var |
+----------------------------------+----------------------------------+-------+ 

Table    = seqn_detection
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| fprint_accn                      | varchar()                        |    15 |
| seqn_accn                        | varchar()                        |    15 |
| repeats                          | int4                             |     4 |
| detection                        | char()                           |     1 |
| automatic                        | bool                             |     1 |
+----------------------------------+----------------------------------+-------+ 

Table    = history
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| fprint_accn                      | varchar()                        |    15 |
| dbase_version                    | varchar()                        |    15 |
| convergence                      | int2                             |     2 |
| hit_list_length                  | int2                             |     2 |
| scan_method                      | varchar()                        |    12 |
+----------------------------------+----------------------------------+-------+   

Table    = dbase_xrefn
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| fprint_accn                      | varchar()                        |    15 |
| dbase_name                       | varchar()                        |    15 |
| dbase_accn                       | varchar()                        |    15 |
| dbase_id                         | varchar()                        |    30 |
+----------------------------------+----------------------------------+-------+ 

Table    = true_partial
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| fprint_accn                      | varchar()                        |    15 |
| seqn_accn                        | varchar()                        |    15 |
| matches                          | int2                             |     2 |
| motif_diagram                    | varchar()                        |    15 |
| automatic                        | bool                             |     1 |
+----------------------------------+----------------------------------+-------+ 

Table    = false_partial
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| fprint_accn                      | varchar()                        |    15 |
| seqn_accn                        | varchar()                        |    15 |
+----------------------------------+----------------------------------+-------+ 

Table    = relation
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| fprint_one                       | varchar()                        |    15 |
| relationship                     | text                             |   var |
| fprint_two                       | varchar()                        |    15 |
+----------------------------------+----------------------------------+-------+

Table    = ancestry
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| fprint_id                        | varchar()                        |    15 |
| ancestors                        | text                             |   var |
+----------------------------------+----------------------------------+-------+