| Column | MySQL Type | Oracle Type | Nullable | Description |
|---|---|---|---|---|
| WID | BIGINT | NUMBER | No | WID of this element |
| Name | VARCHAR | VARCHAR2(15) | No | Long name (e.g. 'Oxygen') |
| ElementSymbol | VARCHAR | VARCHAR2(2) | No | Symbol (e.g. 'O') |
| AtomicWeight | FLOAT | NUMBER | No | Weighted average weight (e.g. 16.x) |
| AtomicNumber | SMALLINT | NUMBER | No | Number of protons |
| Table | Column |
|---|---|
| Valence | OtherWID |
| Entry | OtherWID |
| Support | OtherWID |
| Name | Columns |
|---|---|
| ELEMENT_NAME | Name |
| ELEMENT_ELEMENTSYMBOL | ElementSymbol |
| ELEMENT_ATOMICWEIGHT | AtomicWeight |
| ELEMENT_ATOMICNUMBER | AtomicNumber |