profit-wellnes

Tables (10)

boards

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • board_type — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

comments

  • id — SERIAL
  • post_id — INT — Foreign key → posts.id — NOT NULL
  • author_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
  • author_name — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

companies

  • id — VARCHAR(36)
  • name — VARCHAR(200) — NOT NULL
  • industry — VARCHAR(100)
  • employee_count — INT
  • created_at — TIMESTAMP

departments

  • id — VARCHAR(36)
  • company_id — VARCHAR(36) — Foreign key → companies.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • employee_count — INT
  • created_at — TIMESTAMP

employees

  • id — VARCHAR(36)
  • company_id — VARCHAR(36) — Foreign key → companies.id — NOT NULL
  • department_id — VARCHAR(36) — Foreign key → departments.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • position — VARCHAR(50)
  • join_date — DATE
  • created_at — TIMESTAMP

posts

  • id — SERIAL
  • board_id — INT — Foreign key → boards.id — NOT NULL
  • author_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
  • author_name — VARCHAR(100) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • is_pinned — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

sessions

  • session_id — VARCHAR(128)
  • expires — INT — NOT NULL
  • data — TEXT

users

  • id — VARCHAR(255)
  • email — VARCHAR(255)
  • first_name — VARCHAR(100)
  • last_name — VARCHAR(100)
  • profile_image_url — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

welfare_budgets

  • id — VARCHAR(36)
  • company_id — VARCHAR(36) — Foreign key → companies.id — NOT NULL
  • month — VARCHAR(7) — NOT NULL
  • total_budget — BIGINT — NOT NULL
  • allocated_budget — BIGINT
  • description — TEXT
  • created_at — TIMESTAMP

workouts

  • id — VARCHAR(36)
  • employee_id — VARCHAR(36) — Foreign key → employees.id — NOT NULL
  • company_id — VARCHAR(36) — Foreign key → companies.id — NOT NULL
  • department_id — VARCHAR(36) — Foreign key → departments.id — NOT NULL
  • workout_date — DATE — NOT NULL
  • workout_type — VARCHAR(20) — NOT NULL
  • duration_min — INT — NOT NULL
  • calories_burned — INT
  • location — VARCHAR(100)
  • verified — BOOLEAN
  • notes — TEXT
  • created_at — TIMESTAMP