| SchemaSpy Analysis of export - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on Thu Apr 21 06:56 HST 2011 |
| ||||||
|
| |||||||
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 | derivedobject_id | bigint | 20 | √ | null | ||||||||
| mpc_sub | det_id | bigint | 20 | √ | null | ||||||||
| mpc_sub | digest | float | 12 | √ | null | ||||||||
| mpc_sub | discovery | char | 1 | √ | null | ||||||||
| mpc_sub | mpc_desig | varbinary | 20 | √ | null | ||||||||
| mpc_sub | seq_num | bigint | 20 | √ | null |
|
|||||||
| mpc_sub | spatial_idx | bigint | 20 | √ | null | ||||||||
| mpc_sub | survey_mode | varbinary | 40 | √ | null | ||||||||
| mpc_sub | tracklet_id | bigint | 20 | √ | null | ||||||||
| mpc_sub | dec_deg | double | 22 | ||||||||||
| mpc_sub | desig | varbinary | 20 | ||||||||||
| 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 | obscode | char | 3 | ||||||||||
| mpc_sub | ra_deg | double | 22 | ||||||||||
| batch_seq | seq_num | bigint | 20 | √ |
|
auto_increment | |||||||
| desig_seq | seq_num | bigint | 20 | √ |
|
auto_increment | |||||||
| mpc_sub | submitted | timestamp | 19 | CURRENT_TIMESTAMP | |||||||||
| mpc_sub | submitter | varbinary | 20 |