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