SchemaSpy Analysis of postgres.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Feb 20 18:07 CET 2023
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

postgres.public contains 165 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
actor actor_id serial 10  √  nextval('actor_actor_id_seq'::regclass)
address address_id serial 10  √  nextval('address_address_id_seq'::regclass)
category category_id serial 10  √  nextval('category_category_id_seq'::regclass)
city city_id serial 10  √  nextval('city_city_id_seq'::regclass)
country country_id serial 10  √  nextval('country_country_id_seq'::regclass)
customer customer_id serial 10  √  nextval('customer_customer_id_seq'::regclass)
film film_id serial 10  √  nextval('film_film_id_seq'::regclass)
inventory inventory_id serial 10  √  nextval('inventory_inventory_id_seq'::regclass)
language language_id serial 10  √  nextval('language_language_id_seq'::regclass)
payment payment_id serial 10  √  nextval('payment_payment_id_seq'::regclass)
payment_p2007_01 payment_id serial 10  √  nextval('payment_payment_id_seq'::regclass)
payment_p2007_02 payment_id serial 10  √  nextval('payment_payment_id_seq'::regclass)
payment_p2007_03 payment_id serial 10  √  nextval('payment_payment_id_seq'::regclass)
payment_p2007_04 payment_id serial 10  √  nextval('payment_payment_id_seq'::regclass)
payment_p2007_05 payment_id serial 10  √  nextval('payment_payment_id_seq'::regclass)
payment_p2007_06 payment_id serial 10  √  nextval('payment_payment_id_seq'::regclass)
rental rental_id serial 10  √  nextval('rental_rental_id_seq'::regclass)
staff staff_id serial 10  √  nextval('staff_staff_id_seq'::regclass)
store store_id serial 10  √  nextval('store_store_id_seq'::regclass)
customer active int4 10  √  null
staff active bool 1 true
customer activebool bool 1 true
actor_info actor_id int4 10  √  null
film_actor actor_id int2 5
film_list actors text 2147483647  √  null
nicer_but_slower_film_list actors text 2147483647  √  null
address address varchar 50
customer_list address varchar 50  √  null
staff_list address varchar 50  √  null
address address2 varchar 50  √  null
customer address_id int2 5
staff address_id int2 5
store address_id int2 5
payment amount numeric 5,2
payment_p2007_01 amount numeric 5,2
payment_p2007_02 amount numeric 5,2
payment_p2007_03 amount numeric 5,2
payment_p2007_04 amount numeric 5,2
payment_p2007_05 amount numeric 5,2
payment_p2007_06 amount numeric 5,2
film_list category varchar 25  √  null
nicer_but_slower_film_list category varchar 25  √  null
sales_by_film_category category varchar 25  √  null
film_category category_id int2 5
city city varchar 50
customer_list city varchar 50  √  null
staff_list city varchar 50  √  null
address city_id int2 5
country country varchar 50
customer_list country varchar 50  √  null
staff_list country varchar 50  √  null
city country_id int2 5
customer create_date date 13 ('now'::text)::date
payment customer_id int2 5
payment_p2007_01 customer_id int2 5
payment_p2007_02 customer_id int2 5
payment_p2007_03 customer_id int2 5
payment_p2007_04 customer_id int2 5
payment_p2007_05 customer_id int2 5
payment_p2007_06 customer_id int2 5
rental customer_id int2 5
film description text 2147483647  √  null
film_list description text 2147483647  √  null
nicer_but_slower_film_list description text 2147483647  √  null
address district varchar 20
customer email varchar 50  √  null
staff email varchar 50  √  null
film_list fid int4 10  √  null
nicer_but_slower_film_list fid int4 10  √  null
film_actor film_id int2 5
film_category film_id int2 5
inventory film_id int2 5
actor_info film_info text 2147483647  √  null
actor first_name varchar 45
actor_info first_name varchar 45  √  null
customer first_name varchar 45
staff first_name varchar 45
film fulltext tsvector 2147483647
customer_list id int4 10  √  null
staff_list id int4 10  √  null
rental inventory_id int4 10
film language_id int2 5
actor last_name varchar 45
actor_info last_name varchar 45  √  null
customer last_name varchar 45
staff last_name varchar 45
actor last_update timestamp 29,6 now()
address last_update timestamp 29,6 now()
category last_update timestamp 29,6 now()
city last_update timestamp 29,6 now()
country last_update timestamp 29,6 now()
customer last_update timestamp 29,6  √  now()
film last_update timestamp 29,6 now()
film_actor last_update timestamp 29,6 now()
film_category last_update timestamp 29,6 now()
inventory last_update timestamp 29,6 now()
language last_update timestamp 29,6 now()
rental last_update timestamp 29,6 now()
staff last_update timestamp 29,6 now()
store last_update timestamp 29,6 now()
film length int2 5  √  null
film_list length int2 5  √  null
nicer_but_slower_film_list length int2 5  √  null
sales_by_store manager text 2147483647  √  null
store manager_staff_id int2 5
category name varchar 25
customer_list name text 2147483647  √  null
language name bpchar 20
staff_list name text 2147483647  √  null
customer_list notes text 2147483647  √  null
film original_language_id int2 5  √  null
staff password varchar 40  √  null
payment payment_date timestamp 29,6
payment_p2007_01 payment_date timestamp 29,6
payment_p2007_02 payment_date timestamp 29,6
payment_p2007_03 payment_date timestamp 29,6
payment_p2007_04 payment_date timestamp 29,6
payment_p2007_05 payment_date timestamp 29,6
payment_p2007_06 payment_date timestamp 29,6
address phone varchar 20
customer_list phone varchar 20  √  null
staff_list phone varchar 20  √  null
staff picture bytea 2147483647  √  null
address postal_code varchar 10  √  null
film_list price numeric 4,2  √  null
nicer_but_slower_film_list price numeric 4,2  √  null
film rating mpaa_rating 2147483647  √  'G'::mpaa_rating
film_list rating mpaa_rating 2147483647  √  null
nicer_but_slower_film_list rating mpaa_rating 2147483647  √  null
film release_year year 10  √  null
rental rental_date timestamp 29,6
film rental_duration int2 5 3
payment rental_id int4 10
payment_p2007_01 rental_id int4 10
payment_p2007_02 rental_id int4 10
payment_p2007_03 rental_id int4 10
payment_p2007_04 rental_id int4 10
payment_p2007_05 rental_id int4 10
payment_p2007_06 rental_id int4 10
film rental_rate numeric 4,2 4.99
film replacement_cost numeric 5,2 19.99
rental return_date timestamp 29,6  √  null
customer_list sid int2 5  √  null
staff_list sid int2 5  √  null
film special_features _text 2147483647  √  null
payment staff_id int2 5
payment_p2007_01 staff_id int2 5
payment_p2007_02 staff_id int2 5
payment_p2007_03 staff_id int2 5
payment_p2007_04 staff_id int2 5
payment_p2007_05 staff_id int2 5
payment_p2007_06 staff_id int2 5
rental staff_id int2 5
sales_by_store store text 2147483647  √  null
customer store_id int2 5
inventory store_id int2 5
staff store_id int2 5
film title varchar 255
film_list title varchar 255  √  null
nicer_but_slower_film_list title varchar 255  √  null
sales_by_film_category total_sales numeric 0  √  null
sales_by_store total_sales numeric 0  √  null
staff username varchar 16
customer_list zip code varchar 10  √  null
staff_list zip code varchar 10  √  null