administration +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Date | datetime | YES | PRI | NULL | | | Entry | varchar(5) | YES | | NULL | | | Name | text | YES | | NULL | | | Comment | text | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+ bibliography +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | PRI | NULL | | | Title | text | YES | | NULL | | | Reference | text | YES | | NULL | | | Volume | text | YES | | NULL | | | Page | text | YES | | NULL | | | Year | int(4) | YES | | NULL | | | Journal | varchar(10) | YES | | NULL | | # selected from dictionary | F_author | text | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+ authors +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Author | text | YES | MUL | NULL | index | | First_n | varchar(3) | YES | MUL | NULL | index | | Middel_n | varchar(3) | YES | MUL | NULL | index | | Affil | text | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+ #object_info observation +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | Comment | text | YES | | NULL | | # Reference, Facility +-----------+-------------+------+-----+---------+-------+ #observation misc +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | Date | date | YES | MUL | NULL | | # Universel Time | JD | int | YES | MUL | NULL | | # Julian Date, MJD? | Facility | text | YES | | NULL | | # selected from dictionary | Resolution| integer | YES | | NULL | | | SN | text | YES | | NULL | | | Exposure | float | YES | | NULL | | | Vrad | text | YES | | NULL | | | Comment | text | YES | | NULL | | # S/N wavelength, Exposure color, S/N per pixel or resolution element +-----------+-------------+------+-----+---------+-------+ #binarity #+-----------+-------------+------+-----+---------+-------+ #| Field | Type | Null | Key | Default | Extra | #+-----------+-------------+------+-----+---------+-------+ #| Entry | varchar(5) | YES | MUL | NULL | | #| Object | varchar(30) | YES | MUL | NULL | | #| Binarity | varchar(1) | YES | | NULL | | Y or N #| Period | float | YES | | NULL | | #| Vrad | float | YES | | NULL | | #| Vrad+D | float | YES | | NULL | | #| Vrad-D | float | YES | | NULL | | #+-----------+-------------+------+-----+---------+-------+ binarity +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | Quantity | varchar(10) | YES | MUL | NULL | | # Binarity(1, 0, -1), Period, Vrad | Value | float | YES | | NULL | | | pDelta | float | YES | | NULL | | | mDelta | float | YES | | NULL | | | ErrFlag | varchar(1) | YES | | NULL | | # <, > | Source | text | YES | | NULL | | # reference +-----------+-------------+------+-----+---------+-------+ position +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | RA | varchar(20) | YES | MUL | NULL | | # Right Ascension | Decl | varchar(20) | YES | MUL | NULL | | # Declination | l | varchar(15) | YES | MUL | NULL | | # Galactic Longitude | b | varchar(15) | YES | MUL | NULL | | # Galactic Lattitude | Comment | text | YES | | NULL | | # J2000.0 for R.A., Decl., Reference +-----------+-------------+------+-----+---------+-------+ simbad_position +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | | NULL | | | Object | varchar(30) | YES | | NULL | | | Distance | float | YES | | NULL | | | Coord_X | float | YES | | NULL | | | Coord_Y | float | YES | | NULL | | | Coord_Z | float | YES | | NULL | | | longitude | varchar(15) | YES | | NULL | | | latitude | varchar(15) | YES | | NULL | | | RV | float | YES | | NULL | | | VX | float | YES | | NULL | | | VY | float | YES | | NULL | | | VZ | float | YES | | NULL | | | Luminosity | float | YES | | NULL | | | Mabs | float | YES | | NULL | | +------------+-------------+------+-----+---------+-------+ atmosphere +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | Parameter | varchar(20) | YES | | NULL | | Teff, log g, [Fe/H], v_turb | Value | float | YES | | NULL | | | pDelta | float | YES | | NULL | | | mDelta | float | YES | | NULL | | | ErrFlag | varchar(1) | YES | | NULL | | # <, > | Source | text | YES | | NULL | | # reference +-----------+-------------+------+-----+---------+-------+ abundance +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | Quantity | varchar(20) | YES | MUL | NULL | | | Nline | int(3) | YES | | NULL | | | Value | float | YES | | NULL | | | pDelta | float | YES | | NULL | | | mDelta | float | YES | | NULL | | | ErrFlag | varchar(1) | YES | | NULL | | # <, > | Source | float | YES | | NULL | | # reference -> Rating (temporary) +-----------+-------------+------+-----+---------+-------+ element_quantity +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Quantity | varchar(20) | YES | MUL | NULL | | | Z | varchar(2) | YES | | NULL | | | A | varchar(2) | YES | | NULL | | | State | varchar(5) | YES | | NULL | | | Unit | varchar(10) | YES | | NULL | | # log e, [X/H], [X/Fe] +-----------+-------------+------+-----+---------+-------+ width +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | Quantity | varchar(20) | YES | MUL | NULL | | | Value | float | YES | | NULL | | | pDelta | float | YES | | NULL | | | mDelta | float | YES | | NULL | | | ErrFlag | varchar(1) | YES | | NULL | | # <, > | Source | text | YES | | NULL | | # reference +-----------+-------------+------+-----+---------+-------+ width_quantity +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Quantity | varchar(20) | YES | MUL | NULL | | | Z | varchar(2) | YES | | NULL | | | A | varchar(2) | YES | | NULL | | | State | varchar(5) | YES | | NULL | | | Unit | varchar(10) | YES | | NULL | | log e, EW, log gf, Ex_potential | Wavelength| varchar(8) | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+ photometry +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | Band | varchar(6) | YES | MUL | NULL | | | Value | float | YES | | NULL | | | pDelta | float | YES | | NULL | | | mDelta | float | YES | | NULL | | | ErrFlag | varchar(1) | YES | | NULL | | # <, > | Source | text | YES | | NULL | | # reference +-----------+-------------+------+-----+---------+-------+ solar_ab +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | Element | varchar(8) | YES | MUL | NULL | | # selected from dictionary | Ref_solar | text | YES | | NULL | | # selected from dictionary +-----------+-------------+------+-----+---------+-------+ dictionary +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Category | varchar(20) | YES | MUL | NULL | | | Code | varchar(10) | YES | MUL | NULL | | | Expansion | text | YES | | NULL | | | Comment | text | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+ displist +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | F_author | text | YES | | NULL | | | Reference | text | YES | | NULL | | | FebyH | float | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+ isotope +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | | Quantity | varchar(20) | YES | MUL | NULL | | | Nline | int(3) | YES | | NULL | | | Value | float | YES | | NULL | | | pDelta | float | YES | | NULL | | | mDelta | float | YES | | NULL | | | ErrFlag | varchar(1) | YES | | NULL | | # <, > | Source | text | YES | | NULL | | # reference +-----------+-------------+------+-----+---------+-------+ synonym +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Entry | varchar(5) | YES | MUL | NULL | | | Object | varchar(30) | YES | MUL | NULL | | # Original object name | ObjectC | varchar(30) | YES | MUL | NULL | | # Converted object name | Ref_solar | text | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+