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_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