| SchemaSpy Analysis of postgres.public - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on Mon Feb 20 18:07 CET 2023 |
| ||||||
|
| |||||||
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 | varchar | 50 | √ | null | |||
| staff | 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 |