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

career

    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

    evaluation

    • Field
    • Field2

    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

    resume

      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