podoc:film_type_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:film_type_sql_table [2007/04/12 12:32] – Luud | podoc:film_type_sql_table [2007/04/20 12:42] (current) – Luud | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Database Table Description ===== | + | ===== Database Table Description |
=== Name === | === Name === | ||
+ | |||
+ | film_type | ||
=== Description === | === Description === | ||
Line 8: | Line 10: | ||
=== Schema === | === Schema === | ||
+ | |||
+ | <code sql> | ||
+ | create table film_type ( | ||
+ | identifier | ||
+ | manufacturer | ||
+ | model | ||
+ | iso | ||
+ | format | ||
+ | last_modified_date timestamp, | ||
+ | last_modifying_users integer references users(identifier) | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | === 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 === | === Related sequences === | ||
+ | |||
+ | * [[film_type_id_sequence sql sequence|film_type_id_sequence]] | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | * [[film_type_manufacturer_idx sql index|film_type_manufacturer_idx]] | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | * [[number_of_manufacturer_ref sql function|number_of_manufacturer_ref]] | ||
=== Related views === | === Related views === | ||
+ | |||
+ | * [[view_film sql view|view_film]] | ||
+ | * [[view_film_type sql view|view_film_type]] | ||
=== History === | === History === | ||
Line 31: | Line 65: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | | + | create table film_type |
- | ); | + | |
+ | | ||
+ | model | ||
+ | iso | ||
+ | format | ||
+ | last_modified_date timestamp, | ||
+ | last_modifying_users integer references users(identifier) | ||
+ | ); | ||
+ | </ |
podoc/film_type_sql_table.1176381158.txt.gz · Last modified: 2007/04/12 12:32 by Luud