AG Cloud

Tables (3)

Untitled (tb_role)

  • Key (role_id) — serial — Primary key — NOT NULL
  • Field (role_name) — text — NOT NULL

project (tb_project)

  • Key (project_id) — serial — Primary key — NOT NULL
  • user_id (person_id) — int — Foreign key → user.user_id — NOT NULL
  • Field (create_date) — timestamp — NOT NULL
  • Field (update_date) — timestamp
  • Field (project_name) — text
  • Field (project_type) — text
  • Field2 (project_database) — text
  • Field3 (project_graphpath) — text
  • Field4 (project_username) — text
  • Field5 (project_password) — text
  • Field (is_extend) — int

user (tb_person)

  • user_id (person_id) — serial — Primary key — NOT NULL
  • Key (role_id) — int — Foreign key → Untitled.Key — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • Field5 (email) — text
  • Field6 (password) — text
  • Field (name) — text
  • Field (company) — text
  • Field (is_enable) — int — NOT NULL