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