User Tools

Site Tools


podoc:film_sql_table

Database Table Description of "film"

Name

film

Description

Purpose

Schema

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

References tables

Is referenced by tables

History

Used first

Version 2.5

Used last

Still in use

Change history

= 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)
);
podoc/film_sql_table.txt · Last modified: 2007/04/20 14:25 by Luud