Karis

Tables (11)

Business (Untitled2)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (userId) — integer — Foreign key → Users.Key — NOT NULL
  • Field (company_name) — string
  • Field (business_number) — string
  • Field (department) — string
  • Field (status) — string

FAQ (Untitled3)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (created_by) — integer — Foreign key → Users.Key — NOT NULL
  • Field (question) — string
  • Field (answer) — string
  • Field (status) — integer
  • Field (type) — integer

Invate_member (Untitled10)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (projectId) — integer — Foreign key → Project.Key — NOT NULL
  • Field (email) — string
  • Field (invitations) — string
  • s (status) — integer

Project (Untitled5)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (ownerId) — integer — Foreign key → Users.Key — NOT NULL
  • Field (name) — string
  • Field (image) — string
  • Field (status) — integer
  • Field (isPublic) — boolean

Project_properties (Untitled8)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (projectId) — integer — Foreign key → Project.Key — NOT NULL
  • Field (text) — string
  • Field (pages) — string
  • Field (to_do_list) — string
  • Field (title_1) — string
  • Field (title_2) — string
  • Field (marked) — string
  • Field (title_3) — string
  • Field (table) — string
  • Field (bullet_list) — string
  • Field (numbering_list) — string
  • Field (citation) — string
  • Field (step_link) — string
  • Field (callout) — string
  • Field (user_mention) — string
  • Field (step_mention) — string
  • Field (date_of_remain) — Date
  • Field (Emoji) — string
  • Field (Image) — string
  • Field (bookmarks) — string
  • Field (video) — string
  • Field (audio) — string
  • Field (File) — string
  • Field (font_color) — string
  • Field (font_backgroud_color) — string

Project_role (Untitled7)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (projectId) — integer — Foreign key → Project.Key — NOT NULL
  • Key (userId) — integer — Foreign key → Users.Key — NOT NULL
  • Field (role) — integer
  • Field (status) — integer

Projects_image (Untitled6)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (project_id) — integer — Foreign key → Project.Key — NOT NULL
  • Key (id2) — integer — Foreign key → Project.Key — NOT NULL
  • Field (image_display) — string

Send_email_histories (Untitled9)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (projectId) — integer — Foreign key → Project.Key — NOT NULL
  • Field (email) — string
  • Field (status) — string

User_setting (Untitled4)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (userId) — integer — Foreign key → Users.Key — NOT NULL
  • Field (desktop) — boolean
  • Field (email) — boolean

Users (Untitled)

  • Key (id) — integer — Primary key — NOT NULL
  • Field (email) — string
  • Field (password) — string
  • Field (phone_number) — string
  • Field (avatar) — string
  • Field (status) — integer

blocks (Untitled11)