test_stock4lio
Tables (20)
Content Type (Home)
- video — not null — Primary key
- motion_graphic — not null — Primary key
- music — not null — Primary key
- sound — not null — Primary key
- photo — not null — Primary key — NOT NULL
Interest (interest)
- id — Primary key — NOT NULL
- Field
- Field2
category
- big_cat — not null — Primary key — NOT NULL
- med_cat — not null — Primary key
- smal_cat — not null — Primary key
- video — not null — Foreign key → Content Type.video
- motion_graphic — not null — Foreign key → Content Type.motion_graphic
- music — not null — Foreign key → Content Type.music
- sound — not null — Foreign key → Content Type.sound
- photo — not null — Foreign key → Content Type.photo — NOT NULL
confirm_email
- id — not null — Primary key — NOT NULL
- user_id — not null — Foreign key → user.id — NOT NULL
- email — not null
- is_main — not null
contact
- id — not null — Foreign key → folio.id — NOT NULL
- group_id — not null — Foreign key → group.id — NOT NULL
- email — null
- phone — null
- fax — null
content
- id — not null — Primary key — NOT NULL
- author_id — not null — Foreign key → folio.id — NOT NULL
- id (id2) — not null — Foreign key → folio.role_id — NOT NULL
- title — not null
- description — not null
- preview — not null
- big_cat — not null — Foreign key → category.big_cat — NOT NULL
- med_cat — not null — Foreign key → category.med_cat
- smal_cat — not null — Foreign key → category.smal_cat
- file_id — not null — Foreign key → file.id — NOT NULL
- license (licesne) — not null — Foreign key → file.license — NOT NULL
content tag (content tag)
- tag_id — not null — Foreign key → tag.id — NOT NULL
- content_tag_id — not null — Foreign key → content.id — NOT NULL
content file
- file_id — not null — Foreign key → file.id — NOT NULL
- content_id — not null — Foreign key → content.id — NOT NULL
- author_id — not null — Foreign key → content.author_id — NOT NULL
- license — not null — Foreign key → file.license — NOT NULL
- id (id2) — not null — Foreign key → content.id — NOT NULL
file
- id — not null — Primary key — NOT NULL
- license (licesne) — null — Primary key — NOT NULL
- name — null
- attach_type — not null
- byte_size — not null
- height — null
- width — null
folio
- id — not null — Primary key — NOT NULL
- role_id — not null — Foreign key → role.id — NOT NULL
- nickname — not null
- picture — not null
- picture_type — not null
- are_friends — not null — Foreign key → friend.are_friends — NOT NULL
- mutual_friends — not null — Foreign key → friend.friend_id — NOT NULL
- profession — null
- active — not null
- group_id — null — Foreign key → group.id — NOT NULL
friend
- are_friends — not null — Primary key — NOT NULL
- friend_id — not null — Foreign key → folio.id — NOT NULL
- id (id22) — not null — Foreign key → folio.role_id — NOT NULL
- friend_id2 — not null — Foreign key → folio.id — NOT NULL
group
- id — not null — Primary key — NOT NULL
- name — not null
- type — not null
- logo — null
- enabled — not null
- locked — not null
- group_info — null
- start_date — null
role
- id — not null — Primary key — NOT NULL
- auth1 — not null
- auth2 — not null
state
- active (Field) — not null
- pending — not null
- reject — not null
tag
- id — not null — Primary key — NOT NULL
- date_created — not null
- description — null
- name — not null
- tagged_count — not null
user
- id — not null — Primary key — NOT NULL
- username — not null
- date_created — not null
- date_withdraw — not null
- last_password_changed — not null
- create_ip — null
- password — not null
- enabled — not null
- withdraw — not null
- last_update_ip — null
- last_updated — not null
user_role
- user_id — not null — Foreign key → user.id — NOT NULL
- role_id — not null — Foreign key → role.id — NOT NULL