film

CREATE TABLE film (
  identifier            integer NOT NULL PRIMARY KEY,
  type                  integer NOT NULL REFERENCES film_type(identifier),
  users                 integer NOT NULL REFERENCES users(identifier),
  access_rights         integer NOT NULL REFERENCES access_type(identifier)
);

• access_rights references access_type(identifier)
• type references film_type(identifier)
• users references users(identifier)

• photo_tech(film) references identifier

• film_id_sequence

• film_type_idx
• film_users_idx

• count_equipment_by_user
• number_of_film_references

• view_film

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE film (
  identifier            integer NOT NULL PRIMARY KEY,
  type                  integer NOT NULL REFERENCES film_type(identifier),
  users                 integer NOT NULL REFERENCES users(identifier),
  access_rights         integer NOT NULL REFERENCES access_type(identifier)
);