Pagila (sample PostgreSQL database)

- Pagila

public.store

Documentation	Pagila
Schema	public
Name	store
Module	Business

Contains the store data including manager staff and address

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		store_id	integer		Default: nextval('store_store_id_seq'::regclass)		A surrogate primary key that uniquely identifies the store.
A surrogate primary key that uniquely identifies the store. Default: nextval('store_store_id_seq'::regclass)
	2		manager_staff_id	smallint			public.staff	A foreign key identifying the manager of this store.
A foreign key identifying the manager of this store. References: public.staff
	3		address_id	smallint			public.address	A foreign key identifying the address of this store.
A foreign key identifying the address of this store. References: public.address
	4		last_update	timestamp without time zone(6)		Default: now()		The time that the row was created or most recently updated.
The time that the row was created or most recently updated. Default: now()

Relations

Foreign table		Primary table	Join	Title / Name / Description
public.store		public.address	public.store.address_id = public.address.address_id	store_address_id_fkey Foreign key constraint referencing address.address_id
public.store.address_id = public.address.address_id Name: store_address_id_fkey Foreign key constraint referencing address.address_id
public.store		public.staff	public.store.manager_staff_id = public.staff.staff_id	store_manager_staff_id_fkey Foreign key constraint referencing staff.staff_id
public.store.manager_staff_id = public.staff.staff_id Name: store_manager_staff_id_fkey Foreign key constraint referencing staff.staff_id
public.customer		public.store	public.customer.store_id = public.store.store_id	customer_store_id_fkey Foreign key constraint referencing store.store_id
public.customer.store_id = public.store.store_id Name: customer_store_id_fkey Foreign key constraint referencing store.store_id
public.inventory		public.store	public.inventory.store_id = public.store.store_id	inventory_store_id_fkey Foreign key constraint referencing store.store_id
public.inventory.store_id = public.store.store_id Name: inventory_store_id_fkey Foreign key constraint referencing store.store_id
public.staff		public.store	public.staff.store_id = public.store.store_id	staff_store_id_fkey Foreign key constraint referencing store.store_id
public.staff.store_id = public.store.store_id Name: staff_store_id_fkey Foreign key constraint referencing store.store_id

Unique keys

	Key name	Columns	Description
	store_pkey	store_id	Primary key.
Primary key.

Triggers

	Key name	When	Description
	last_updated	Before Update	The last_updated trigger sets last_update column of table to the current timestamp.
EXECUTE PROCEDURE last_updated()
The last_updated trigger sets last_update column of table to the current timestamp.
EXECUTE PROCEDURE last_updated()

Uses

Name
public.store
public.address
public.staff

Used by

Name
public.store
public.sales_by_store
public.customer
public.inventory
public.staff

Exported: 2018-10-12 17:07, Last imported: 2018-08-06 09:25