JOURNAL
Contents: periodicals / journals
Referencing tables: reference |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | User who first saved record | |
| date_added | datetime | Timestamp when record was created | |
| user_changed | varchar | User who last saved record | |
| date_changed | datetime | ||
| journal_name | varchar | shortened name of the journal | |
| journal_short | varchar | ||
| journal_abbr | varchar | ||
| journal_long | varchar | full name of the journal | |
| journal_original | varchar | ||
| issn | varchar | ISSN number | |
| publisher | varchar | publisher | |
| publisher_place | varchar | location of the publisher | |
| http | varchar | home page for the journal | |
| former_journal | int | journal | |
| following_journal | int | journal | |
| oldname | varchar | the former name of the journal | |
| newname | varchar | the current name of the journal | |
| remarks | text | additional information about publication | |
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| timestamp | datetime | timestamp that also reflects date when data was last saved, generated by database engine |
