Tables Relationships Utility Tables Constraints Anomalies Columns Donate

SchemaSpy Analysis of export - Columns | Generated by SchemaSpy

Generated by SchemaSpy on Thu Apr 21 06:56 HST 2011 |
Legend: |
Primary key columns
Columns with indexes
Related columns Constraint names Comments Legend

export contains 24 columns - click on heading to sort:

Table | Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
mpc_sub | batch_num | bigint | 20 | √ |  | null |  |  |
mpc_sub | dbname | varchar | 40 | √ |  | null |  |  |
mpc_sub | dec_deg | double | 22 |  |  |  |  |  |
mpc_sub | derivedobject_id | bigint | 20 | √ |  | null |  |  |
mpc_sub | desig | varbinary | 20 |  |  |  |  |  |
mpc_sub | det_id | bigint | 20 | √ |  | null |  |  |
mpc_sub | digest | float | 12 | √ |  | null |  |  |
mpc_sub | discovery | char | 1 | √ |  | null |  |  |
mpc_sub | disposition | char | 1 |  |  |  |  |  |
mpc_sub | epoch_mjd | double | 22 |  |  |  |  |  |
mpc_sub | filter_id | char | 1 |  |  |  |  |  |
mpc_sub | fpa_id | varbinary | 20 |  |  |  |  |  |
mpc_sub | mag | float | 12 |  |  |  |  |  |
mpc_sub | mpc_desig | varbinary | 20 | √ |  | null |  |  |
mpc_sub | obscode | char | 3 |  |  |  |  |  |
mpc_sub | ra_deg | double | 22 |  |  |  |  |  |
batch_seq | seq_num | bigint | 20 |  | √ |  |
desig_seq.seq_num | Implied Constraint
mpc_sub.seq_num | Implied Constraint
|  | auto_increment
desig_seq | seq_num | bigint | 20 |  | √ |  |  |
batch_seq.seq_num | Implied Constraint
| auto_increment
mpc_sub | seq_num | bigint | 20 | √ |  | null |  |
batch_seq.seq_num | Implied Constraint
mpc_sub | spatial_idx | bigint | 20 | √ |  | null |  |  |
mpc_sub | submitted | timestamp | 19 |  |  | CURRENT_TIMESTAMP |  |  |
mpc_sub | submitter | varbinary | 20 |  |  |  |  |  |
mpc_sub | survey_mode | varbinary | 40 | √ |  | null |  |  |
mpc_sub | tracklet_id | bigint | 20 | √ |  | null |  |  |