podoc:film_type_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
podoc:film_type_sql_table [2007/04/19 08:35] – Luud | podoc:film_type_sql_table [2007/04/20 12:41] – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | identifier | + | create table film_type ( |
- | manufacturer | + | identifier |
- | model | + | manufacturer |
- | iso | + | model |
- | format | + | iso |
- | last_modified_date timestamp, | + | format |
- | last_modifying_users integer references users(identifier) | + | 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 === | ||
Line 52: | Line 65: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | identifier | + | create table film_type ( |
- | manufacturer | + | identifier |
- | model | + | manufacturer |
- | iso | + | model |
- | format | + | iso |
- | last_modified_date timestamp, | + | format |
- | last_modifying_users integer references users(identifier) | + | last_modified_date timestamp, |
- | ); | + | last_modifying_users integer references users(identifier) |
+ | ); | ||
+ | </ |
podoc/film_type_sql_table.txt · Last modified: 2007/04/20 12:42 by Luud