171 lines
2.8 KiB
Plaintext
171 lines
2.8 KiB
Plaintext
Table "staff" {
|
|
"id" int [pk]
|
|
"first_name" varchar
|
|
"last_name" varchar
|
|
"address_id" int
|
|
"picture" blob
|
|
"email" varchar
|
|
"store_id" int
|
|
"active" boolean
|
|
"user_name" varchar
|
|
"password" varchar
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "store" {
|
|
"id" int [pk]
|
|
"manager_staff_id" int
|
|
"address_id" int
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "payment" {
|
|
"id" int [pk]
|
|
"customer_id" int
|
|
"staff_id" int
|
|
"rental_id" int
|
|
"amount" decimal
|
|
"payment_date" datetime
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "rental" {
|
|
"id" int [pk]
|
|
"rental_date" datetime
|
|
"inventory_id" int
|
|
"customer_id" int
|
|
"return_date" ddatetime
|
|
"staff_id" int
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Ref:"store"."id" < "staff"."store_id"
|
|
|
|
Ref:"staff"."id" < "store"."manager_staff_id"
|
|
|
|
Ref:"staff"."id" < "payment"."staff_id"
|
|
|
|
Ref:"rental"."id" < "payment"."rental_id"
|
|
|
|
Ref:"staff"."id" < "rental"."staff_id"
|
|
Table "country" {
|
|
"id" int [pk]
|
|
"country" varchar
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "city" {
|
|
"id" int [pk]
|
|
"city" varchar
|
|
"country_id" int
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "address" {
|
|
"id" int [pk]
|
|
"address" varchar
|
|
"address2" varchar
|
|
"district" varchar
|
|
"city_id" int
|
|
"postal_code" varchar
|
|
"phone" varchar
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "customer" {
|
|
"id" int [pk]
|
|
"store_id" int
|
|
"first_name" varchar
|
|
"last_name" varchar
|
|
"email" varchar
|
|
"address_id" int
|
|
"active" boolean
|
|
"create_Date" timestamp
|
|
"last_update" timestamp
|
|
|
|
Indexes {
|
|
(id, first_name) [type: btree]
|
|
}
|
|
}
|
|
|
|
Ref:"country"."id" < "city"."country_id"
|
|
|
|
Ref:"city"."id" < "address"."city_id"
|
|
|
|
Ref:"address"."id" < "customer"."address_id"
|
|
Table "category" {
|
|
"id" int [pk]
|
|
"name" varchar
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "film_category" {
|
|
"id" int [pk]
|
|
"category_id" int
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "language" {
|
|
"id" int [pk]
|
|
"name" varchar
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "film_text" {
|
|
"id" int [pk]
|
|
"film_id" int
|
|
"title" varchar
|
|
"description" text
|
|
}
|
|
|
|
Table "actor" {
|
|
"id" int [pk]
|
|
"first_name" varchar
|
|
"last_name" varchar
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "film" {
|
|
"id" int [pk]
|
|
"title" varchar
|
|
"description" text
|
|
"releaase_year" int
|
|
"language_id" int
|
|
"original_language_id" int
|
|
"rental_duration" int
|
|
"rental_rate" decimal
|
|
"length" int
|
|
"replacement_cost" decimal
|
|
"rating" varchar
|
|
"special_feature" varchar
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "film_actor" {
|
|
"id" int [pk]
|
|
"film_id" int
|
|
"actor_id" int
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Table "inventory" {
|
|
"id" int [pk]
|
|
"film_id" int
|
|
"store_id" int
|
|
"last_update" timestamp
|
|
}
|
|
|
|
Ref:"category"."id" < "film_category"."category_id"
|
|
|
|
Ref:"inventory"."film_id" < "film_text"."film_id"
|
|
|
|
Ref:"language"."id" < "film"."language_id"
|
|
|
|
Ref:"language"."id" < "film"."original_language_id"
|
|
|
|
Ref:"film"."id" < "film_actor"."film_id"
|
|
|
|
Ref:"actor"."id" < "film_actor"."actor_id"
|
|
|
|
Ref:"film"."id" < "inventory"."film_id"
|