sss

Tables (27)

Field

  • field_name — VARCHAR(255)

Issue

  • issue_id — SERIAL
  • issue_title — VARCHAR(255) — NOT NULL
  • issue_description — TEXT
  • issue_status — VARCHAR(20)
  • 완료)) — DEFAULT
  • kanban_id — INT
  • created_at — TIMESTAMP

Kanban

  • kanban_id — SERIAL
  • kanban_name — VARCHAR(255) — NOT NULL
  • project_id — INT
  • created_at — TIMESTAMP

Profile

  • user_id — VARCHAR(255)
  • bio — TEXT

Project

  • project_id — SERIAL
  • project_name — VARCHAR(255) — NOT NULL
  • project_start_date — DATE — NOT NULL
  • project_end_date — DATE — NOT NULL

Stack

  • stack_name — VARCHAR(255)

Team

  • team_name — VARCHAR(255)
  • description — VARCHAR(255)

admin_role_users

  • user_id — VARCHAR(255)
  • role_name — VARCHAR(255)

checkusers

  • user_id — VARCHAR(255)
  • username — VARCHAR(255) — NOT NULL
  • birth_date — DATE — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL

employee_role_users

  • user_id — VARCHAR(255)
  • role_name — VARCHAR(255)

field

  • field_name — character — NOT NULL

issue

  • issue_id — integer — NOT NULL
  • issue_name — character — NOT NULL
  • status — character
  • project_name — character — NOT NULL
  • user_id — character
  • 완료::character — varying)::text)))

kanban

  • kanban_id — integer — NOT NULL
  • kanban_name — character — NOT NULL
  • project_id — integer
  • created_at — timestamp

leader_role_users

  • user_id — VARCHAR(255)
  • role_name — VARCHAR(255)

pending_users

  • user_id — VARCHAR(255)
  • username — VARCHAR(255) — NOT NULL
  • birth_date — DATE — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL

profile

  • user_id — character — NOT NULL
  • bio — text

project

  • project_id — integer — NOT NULL
  • project_name — character — NOT NULL
  • project_start_date — date
  • project_end_date — date
  • team_name — character

relation_project_stack

  • project_name — character — NOT NULL
  • stack_name — character — NOT NULL

relation_team_users

  • team_name — VARCHAR(255)
  • user_id — VARCHAR(255)
  • role_name — VARCHAR(255)

relation_users_field_name

  • user_id — VARCHAR(255)
  • field_name — VARCHAR(255)

role

  • role_name — VARCHAR(255)

role_permission

  • role_name — VARCHAR(255)
  • pending_users_view — BOOLEAN
  • pending_users_reject — BOOLEAN
  • pending_users_submit — BOOLEAN
  • team_submit — BOOLEAN
  • project_submit — BOOLEAN
  • work_state_view — BOOLEAN
  • users_salary_view — BOOLEAN
  • db_gui_view — BOOLEAN
  • db_gui_submit — BOOLEAN
  • users_view — BOOLEAN
  • users_submit — BOOLEAN
  • users_request_submit — BOOLEAN
  • project_work_submit — BOOLEAN

stack

  • stack_name — character — NOT NULL
  • stack_type — character — NOT NULL
  • Language::character — varying
  • Database::character — varying)::text)))

sub_admin_role_users

  • user_id — VARCHAR(255)
  • role_name — VARCHAR(255)

team

  • team_name — character — NOT NULL
  • description — character

users

  • user_id — VARCHAR(255)
  • username — VARCHAR(255) — NOT NULL
  • birth_date — DATE — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL

users_salary

  • user_id — VARCHAR(255)
  • salary — INT