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) | ||
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 | 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 | 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) |