Table postgres.public.staff Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
staff_id serial 10  √  nextval('staff_staff_id_seq'::regclass)
payment.staff_id payment_staff_id_fkey R
payment_p2007_01.staff_id payment_p2007_01_staff_id_fkey R
payment_p2007_02.staff_id payment_p2007_02_staff_id_fkey R
payment_p2007_03.staff_id payment_p2007_03_staff_id_fkey R
payment_p2007_04.staff_id payment_p2007_04_staff_id_fkey R
payment_p2007_05.staff_id payment_p2007_05_staff_id_fkey R
payment_p2007_06.staff_id payment_p2007_06_staff_id_fkey R
rental.staff_id rental_staff_id_fkey R
store.manager_staff_id store_manager_staff_id_fkey R
first_name varchar 45
last_name varchar 45
address_id int2 5
address.address_id staff_address_id_fkey R
email varchar 50  √  null
store_id int2 5
store.store_id staff_store_id_fkey R
active bool 1 true
username varchar 16
password varchar 40  √  null
last_update timestamp 29,6 now()
picture bytea 2147483647  √  null

Table contained 2 rows at Mon Feb 20 18:07 CET 2023

Indexes:
Column(s) Type Sort Constraint Name
staff_id Primary key Asc staff_pkey

Close relationships  within of separation: