Miribit Workspace

Tables (6)

Department (Untitled2)

  • d_id (Key) — LONG — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)

Flows (Untitled3)

  • f_id (Key) — LONG — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • lastest_run (Field2) — time
  • run_type (Field3) — VARCHAR(50)
  • u_id — LONG — Foreign key → Users.u_id — NOT NULL

Menu (Untitled4)

  • m_id (Key) — LONG — Primary key — NOT NULL
  • parent (Field) — LONG
  • name (Field2) — VARCHAR(50)
  • parameters (Field3) — JSON

Menu Object (Untitled)

  • o_id (Key) — LONG — Primary key — NOT NULL
  • m_id (Key2) — LONG — Foreign key → Menu.m_id — NOT NULL
  • parameters (Field) — JSON

Setting (Untitled5)

  • s_id (Key) — LONG — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • url (Field2) — VARCHAR(100)

Users (User)

  • u_id — LONG — Primary key — NOT NULL
  • NAME (name) — VARCHAR(50)
  • email — VARCHAR(50)
  • pw (Field) — VARCHAR(50)
  • d_id (Key) — LONG — Foreign key → Department.d_id — NOT NULL
  • authority (Field2) — VARCHAR(50)