expert form maker

Tables (13)

tbl_category (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • title (Field2)
  • description (Field)
  • activated (Field3)

tbl_company (Untitled)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → tbl_user.id — NOT NULL
  • nickname (Field3) — unique,chanegeable
  • title (Field)
  • description (Field4)
  • activated (Field2)

tbl_company_form (Untitled5)

  • company_id (Key) — Foreign key → tbl_company.id — NOT NULL
  • form_id (Key2) — Foreign key → tbl_form.id — NOT NULL

tbl_datasource (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • organization (Field)
  • form (Field2)
  • field1~field999 (Field3)

tbl_field (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • form_id (Key2) — Foreign key → tbl_form.id — NOT NULL
  • order_no (Field)
  • type (Field2)

tbl_field_attribute (Untitled13)

  • id (Key) — Foreign key → tbl_field.id — NOT NULL
  • type (Field)
  • defaultValue (Field2)

tbl_form (Untitled3)

  • id (Key2) — Primary key — NOT NULL
  • user_id (Key) — Foreign key → tbl_user.id — NOT NULL
  • category_id (Key3) — Foreign key → tbl_category.id — NOT NULL
  • title (Field)
  • description (Field2)

tbl_group (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → tbl_user.id — NOT NULL
  • title (Field)
  • description (Field2)
  • activated (Field3)

tbl_group_company (Untitled10)

  • group_id (Key) — Foreign key → tbl_group.id — NOT NULL
  • compnay_id (Key2) — Foreign key → tbl_company.id — NOT NULL

tbl_group_user (Untitled9)

  • group_id (Key) — Foreign key → tbl_group.id — NOT NULL
  • user_id (Key2) — Foreign key → tbl_user.id — NOT NULL

tbl_staff (Untitled6)

  • email (Key3) — Primary key — NOT NULL
  • company_id (Key2) — Foreign key → tbl_company.id — NOT NULL
  • name (Field6)
  • phone (Field) — required,unique
  • activated (Field3)
  • start_date (Field4)
  • end_date (Field5)

tbl_template (Untitled12)

  • id (Key) — Primary key — NOT NULL
  • category_id (Key2) — Foreign key → tbl_category.id — NOT NULL
  • form_id (Key22) — Foreign key → tbl_form.id — NOT NULL
  • activated (Field)

tbl_user (Untitled2)

  • id (Key) — Primary key — NOT NULL