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