test2_stock4lio

Tables (28)

ad

    authority

    • Key — not null — Primary key — NOT NULL
    • planKey — not null — Foreign key → plan.serviceKey — NOT NULL

    category (Untitled2)

    • Key — not null — Primary key — NOT NULL
    • parent_id (Key2) — null — Foreign key → category.Key — NOT NULL

    category_l

    • Key — not null — Primary key — NOT NULL
    • stockKey — not null — Foreign key → stock.Key — NOT NULL

    category_m

    • Key — not null — Primary key — NOT NULL
    • stockKey — not null — Foreign key → category_l.stockKey — NOT NULL
    • catLKey — not null — Foreign key → category_l.Key — NOT NULL

    category_s

    • Key — null — Primary key — NOT NULL
    • catMKey — not null — Foreign key → category_m.Key — NOT NULL
    • stockKey — not null — Foreign key → category_m.stockKey — NOT NULL
    • catLKey — not null — Foreign key → category_m.catLKey — NOT NULL

    confirm_email

    • Key — not null — Primary key — NOT NULL
    • userKey — not null — Foreign key → user.Key — NOT NULL
    • email — not null
    • is_main — not null

    contact info

    • groupKey — not null — Foreign key → group.Key — NOT NULL
    • folioKey — not null — Foreign key → folio.Key — NOT NULL
    • type — not null — Foreign key → group.type
    • email — null
    • website — null
    • phone — null
    • fax — null

    content

    • Key — Primary key — NOT NULL
    • fileKey — not null — Foreign key → file.Key — NOT NULL
    • title — not null
    • description — null
    • preview — not null
    • downloaded_count — not null
    • catSKey — null — Foreign key → category_s.Key — NOT NULL
    • catMKey — not null — Foreign key → category_s.catMKey — NOT NULL
    • stockKey — not null — Foreign key → category_s.stockKey — NOT NULL
    • catLKey — not null — Foreign key → category_s.catLKey — NOT NULL
    • folioKey — not null — Foreign key → folio.Key — NOT NULL
    • serviceKey — not null — Foreign key → folio.serviceKey — NOT NULL
    • userKey — not null — Foreign key → folio.userKey — NOT NULL
    • view_count — not null

    content tag

      corporate

      • Key — not null — Primary key — NOT NULL
      • type — not null — Foreign key → group.type
      • passcode — not null
      • folioKey — not null — Foreign key → folio.Key — NOT NULL

      crew

      • Key — Primary key — NOT NULL
      • type — not null — Foreign key → group.type
      • folioKey — not null — Foreign key → folio.Key — NOT NULL

      file

      • Key — not null — Primary key — NOT NULL
      • licenseKey — not null — Foreign key → license.Key — NOT NULL
      • name — not null
      • attach_type — not null
      • byte_size — not null
      • height — null
      • width — null
      • quality — not null

      folio

      • Key — not null — Primary key — NOT NULL
      • serviceKey — not null — Foreign key → service.Key — NOT NULL
      • userKey — not null — Foreign key → user.Key — NOT NULL
      • nickname — not null
      • picture — not null
      • picture_type — not null
      • career — not null
      • resume — null
      • active — not null

      folio tag

        follow

          group

          • Key — not null — Primary key — NOT NULL
          • type — not null — Primary key
          • name — not null
          • logo (logova) — not null
          • group_info — null
          • start_date — not null
          • enabled — not null
          • Field

          group tag

            license

            • Key — not null — Primary key — NOT NULL
            • folioKey — not null — Foreign key → folio.Key — NOT NULL
            • guide — not null

            look4job

              look4user (Untitled)

                message

                  plan

                  • Key — not null — Primary key — NOT NULL
                  • serviceKey — not null — Foreign key → service.Key — NOT NULL

                  service

                  • Key — not null — Primary key — NOT NULL

                  stock

                  • Key — not null — Primary key — NOT NULL
                  • serviceKey — not null — Foreign key → service.Key — NOT NULL

                  tag

                  • Key — Primary key — NOT NULL
                  • date_created — not null
                  • description — null
                  • name — not null
                  • tagged_count — not null

                  user

                  • Key — not null — Primary key — NOT NULL
                  • username — not null
                  • password — not null
                  • enabled — not null
                  • date_created — not null
                  • withdraw — not null
                  • date_withdraw — not null
                  • create_ip — not null
                  • last_update_ip — null
                  • last_update — not null

                  user_role

                  • userKey — not null — Foreign key → user.Key — NOT NULL
                  • authorityKey — not null — Foreign key → authority.Key — NOT NULL
                  • planKey — not null — Foreign key → authority.planKey — NOT NULL