1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
List of indexes
Schema | Name | Type | Table | Primary? | Unique?
--------+-----------------------------------------------------+-------+------------------+----------+---------
public | actor_pkey | index | actor | "YES" | "YES"
public | address_pkey | index | address | "YES" | "YES"
public | category_pkey | index | category | "YES" | "YES"
public | city_pkey | index | city | "YES" | "YES"
public | country_pkey | index | country | "YES" | "YES"
public | customer_pkey | index | customer | "YES" | "YES"
public | film_actor_pkey | index | film_actor | "YES" | "YES"
public | film_category_pkey | index | film_category | "YES" | "YES"
public | film_fulltext_idx | index | film | "NO" | "NO"
public | film_pkey | index | film | "YES" | "YES"
public | idx_actor_last_name | index | actor | "NO" | "NO"
public | idx_fk_address_id | index | customer | "NO" | "NO"
public | idx_fk_city_id | index | address | "NO" | "NO"
public | idx_fk_country_id | index | city | "NO" | "NO"
public | idx_fk_customer_id | index | payment | "NO" | "NO"
public | idx_fk_film_id | index | film_actor | "NO" | "NO"
public | idx_fk_inventory_id | index | rental | "NO" | "NO"
public | idx_fk_language_id | index | film | "NO" | "NO"
public | idx_fk_original_language_id | index | film | "NO" | "NO"
public | idx_fk_payment_p2007_01_customer_id | index | payment_p2007_01 | "NO" | "NO"
public | idx_fk_payment_p2007_01_staff_id | index | payment_p2007_01 | "NO" | "NO"
public | idx_fk_payment_p2007_02_customer_id | index | payment_p2007_02 | "NO" | "NO"
public | idx_fk_payment_p2007_02_staff_id | index | payment_p2007_02 | "NO" | "NO"
public | idx_fk_payment_p2007_03_customer_id | index | payment_p2007_03 | "NO" | "NO"
public | idx_fk_payment_p2007_03_staff_id | index | payment_p2007_03 | "NO" | "NO"
public | idx_fk_payment_p2007_04_customer_id | index | payment_p2007_04 | "NO" | "NO"
public | idx_fk_payment_p2007_04_staff_id | index | payment_p2007_04 | "NO" | "NO"
public | idx_fk_payment_p2007_05_customer_id | index | payment_p2007_05 | "NO" | "NO"
public | idx_fk_payment_p2007_05_staff_id | index | payment_p2007_05 | "NO" | "NO"
public | idx_fk_payment_p2007_06_customer_id | index | payment_p2007_06 | "NO" | "NO"
public | idx_fk_payment_p2007_06_staff_id | index | payment_p2007_06 | "NO" | "NO"
public | idx_fk_staff_id | index | payment | "NO" | "NO"
public | idx_fk_store_id | index | customer | "NO" | "NO"
public | idx_last_name | index | customer | "NO" | "NO"
public | idx_store_id_film_id | index | inventory | "NO" | "NO"
public | idx_title | index | film | "NO" | "NO"
public | idx_unq_manager_staff_id | index | store | "YES" | "NO"
public | idx_unq_rental_rental_date_inventory_id_customer_id | index | rental | "YES" | "NO"
public | inventory_pkey | index | inventory | "YES" | "YES"
public | language_pkey | index | language | "YES" | "YES"
public | payment_pkey | index | payment | "YES" | "YES"
public | rental_pkey | index | rental | "YES" | "YES"
public | staff_pkey | index | staff | "YES" | "YES"
public | store_pkey | index | store | "YES" | "YES"
(44 rows)
|
