taskmate
Tables (10)
files
- id — BIGSERIAL — Primary key — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- stored_name — VARCHAR(255) — NOT NULL
- path — TEXT — NOT NULL
- file_size — BIGINT — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- user_id (uploaded_by) — BIGINT — Foreign key
- created_at — TIMESTAMPTZ — NOT NULL
goals
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- due_date — DATE
- user_id (personal_owner) — BIGINT — Foreign key
- team_id (team_owner) — BIGINT — Foreign key → teams.id
- user_id (created_by) — BIGINT — Foreign key — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
notification_settings
- user_id — BIGINT — Foreign key — NOT NULL
- goal_notification — BOOLEAN — NOT NULL
- todo_notification — BOOLEAN — NOT NULL
- deadline_notification — BOOLEAN — NOT NULL
notifications
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
- type — VARCHAR(50) — NOT NULL
- target_type — notification_target — NOT NULL — goal / todo
- target_id — BIGINT — NOT NULL
- message — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
team_invitations
- id — BIGSERIAL — Primary key — NOT NULL
- team_id — BIGSERIAL — Foreign key → teams.id — NOT NULL
- email — VARCHAR(255) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- user_id (invited_by) — BIGINT — Foreign key — NOT NULL
- invite_token — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ
team_members
- id — BIGSIREAL — Primary key — NOT NULL
- team_id — BIGSERIAL — Foreign key → teams.id — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
- role — team_role — NOT NULL
- joined_at — TIMESTAMPTZ — NOT NULL
teams
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- user_id (created_by) — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
todo_assignees
- id — BIGSERIAL — Primary key — NOT NULL
- todo_id — BIGINT — Foreign key — NOT NULL
- user_id (assignee_id) — BIGINT — Foreign key — NOT NULL
- assigned_at — TIMESTAMPTZ — NOT NULL
todos
- id — BIGSERIAL — Primary key — NOT NULL
- goal_id — BIGINT — Foreign key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- start_date — DATE
- due_date — DATE
- status — todo_status — NOT NULL
- memo — VARCHAR(80)
- user_id (created_by) — BIGINT — Foreign key — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(20) — NOT NULL
- file_id (profile_image_id) — BIGINT — Foreign key
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(255)
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL