| Table index | Symbol index | person | DiscRack database schema |
A person who owns a CD
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| objectid | int8 (8) | no | None | |
| objectversion | int4 (4) | no | None | |
| lastname | varchar (36) | no | '' | The family name of the person |
| firstname | varchar (36) | no | '' | The first name(s) of the person |
| password | varchar (36) | no | '' | A password used to protect this person's data |
| login | varchar (36) | no | '' | A login name the person can use to acccess the system |
(primary key column name in bold)
| Table | Column | Description |
|---|---|---|
| disc | owner | The owner of the disc |
| Index name | Unique | Columns | Description |
|---|---|---|---|
| person_pkey | no | objectid |