podoc:film_type_sql_table
This is an old revision of the document!
Database Table Description of "film_type"
Name
film_type
Description
Purpose
Schema
CREATE TABLE film_type ( identifier INTEGER NOT NULL PRIMARY KEY, manufacturer INTEGER NOT NULL REFERENCES manufacturer(identifier), model VARCHAR(100), iso INTEGER NOT NULL REFERENCES film_iso(identifier), format INTEGER NOT NULL REFERENCES film_format(identifier), last_modified_date TIMESTAMP, last_modifying_users INTEGER REFERENCES users(identifier) ); <code> === REFERENCES TABLES === * format REFERENCES [[film_format SQL TABLE|film_format]](identifier) * iso REFERENCES [[film_iso SQL TABLE|film_iso]](identifier) * last_modifying_users REFERENCES [[users SQL TABLE|users]](identifier) * manufacturer REFERENCES [[manufacturer SQL TABLE|manufacturer]](identifier) === IS referenced BY TABLES === * [[film SQL TABLE|film]](TYPE) REFERENCES identifier === Related sequences === * [[film_type_id_sequence SQL SEQUENCE|film_type_id_sequence]] === Related indexes === * [[film_type_manufacturer_idx SQL INDEX|film_type_manufacturer_idx]] === Related functions === * [[number_of_manufacturer_ref SQL FUNCTION|number_of_manufacturer_ref]] === Related views === * [[view_film SQL VIEW|view_film]] * [[view_film_type SQL VIEW|view_film_type]] === History === == Used FIRST == Version 2.5 == Used LAST == Still IN USE == CHANGE history == = Version 2.5 = <code sql> CREATE TABLE film_type ( identifier INTEGER NOT NULL PRIMARY KEY, manufacturer INTEGER NOT NULL REFERENCES manufacturer(identifier), model VARCHAR(100), iso INTEGER NOT NULL REFERENCES film_iso(identifier), format INTEGER NOT NULL REFERENCES film_format(identifier), last_modified_date TIMESTAMP, last_modifying_users INTEGER REFERENCES users(identifier) );
podoc/film_type_sql_table.1177072909.txt.gz · Last modified: 2007/04/20 12:41 by Luud