Merge biblio and biblioitems tables RFC
Jump to navigation
Jump to search
Merge biblio and biblioitems tables
- 1-1 relation is error-prone and adds unnecessary complexity to code.
- I've identified the following columns from the two tables that are still in use.
- Frameworks will have to be adjusted.
- If any columns are missing that have any functionality , please add them.
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| biblionumber | int(11) | NO | PRI | NULL | auto_increment |
| frameworkcode | varchar(4) | NO | |||
| author | mediumtext | YES | NULL | ||
| title | mediumtext | YES | NULL | ||
| unititle | mediumtext | YES | NULL | ||
| serial | tinyint(1) | YES | NULL | ||
| seriestitle | mediumtext | YES | NULL | ||
| copyrightdate | smallint(6) | YES | NULL | ||
| timestamp | timestamp | NO | CURRENT_TIMESTAMP | ||
| datecreated | date | NO | NULL | ||
| abstract | mediumtext | YES | NULL | ||
| isbn | varchar(14) | YES | MUL | NULL | |
| issn | varchar(9) | YES | NULL | ||
| publicationyear | text | YES | NULL | ||
| publishercode | varchar(255) | YES | MUL | NULL | |
| collectiontitle | mediumtext | YES | NULL | ||
| collectionissn | text | YES | NULL | ||
| collectionvolume | mediumtext | YES | NULL | ||
| editionstatement | text | YES | NULL | ||
| editionresponsibility | text | YES | NULL | ||
| timestamp | timestamp | NO | CURRENT_TIMESTAMP | ||
| illus | varchar(255) | YES | NULL | ||
| pages | varchar(255) | YES | NULL | ||
| notes | mediumtext | YES | NULL | ||
| size | varchar(255) | YES | NULL | ||
| place | varchar(255) | YES | NULL | ||
| totalissues | int(10) | YES | NULL | ||
| marcxml | longtext | NO | NULL |