POS/2.30/Database Model/people
Contents |
PEOPLE
Description
Columns
This table contains the following columns:
Name | PK | Nullable | Data Type | Default | Description |
ID | Y | N | VARCHAR | ||
NAME | N | N | VARCHAR | ||
APPPASSWORD | N | Y | VARCHAR | ||
CARD | N | Y | VARCHAR | ||
ROLE | N | N | VARCHAR | ||
VISIBLE | N | N | BOOLEAN | ||
IMAGE | N | Y | BYTEA |
Foreign Keys
These are the foreign keys for this table:
Name | Referencing column | Referenced table | Referenced column | Description |
PEOPLE_FK_1 | ROLE | ROLES | ID |
Indexes
These are the indexes for this table (for each index there is a list of the columns included within it):
Name | Unique | Reference | Description |
PEOPLE_NAME_INX | Y | NAME - | |
PEOPLE_CARD_INX | N | CARD - |
Languages: |
POS/2.30/Database Model/payments | POS/2.30/Database Model/places