profit-wellnes2

Tables (11)

boards

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

comments

  • id — BIGINT
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL
  • author_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • company_id — VARCHAR(36) — Foreign key → companies.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

companies

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

departments

  • id — VARCHAR(36) — Primary key — NOT NULL
  • 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) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id
  • 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
  • position — VARCHAR(50)
  • join_date — DATE
  • created_at — TIMESTAMP

posts

  • id — BIGINT
  • board_id — BIGINT — Foreign key → boards.id — NOT NULL
  • author_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • company_id — VARCHAR(36) — Foreign key → companies.id — 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) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • expires — INT — NOT NULL
  • data — TEXT

users

  • id — VARCHAR(36) — Primary key — NOT NULL
  • email — VARCHAR(255)
  • first_name — VARCHAR(100)
  • last_name — VARCHAR(100)
  • profile_image_url — TEXT
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

welfare_budgets

  • id — VARCHAR(36) — Primary key — NOT NULL
  • company_id — VARCHAR(36) — Foreign key → companies.id — NOT NULL
  • budget_month — DATE — NOT NULL
  • total_budget — BIGINT — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP

welfare_spendings

  • id — VARCHAR(36) — Primary key — NOT NULL
  • company_id — VARCHAR(36) — Foreign key → companies.id — NOT NULL
  • budget_id — VARCHAR(36) — Foreign key → welfare_budgets.id — NOT NULL
  • workout_id — VARCHAR(36) — Foreign key → workouts.id
  • amount — BIGINT — NOT NULL
  • spend_date — DATE — NOT NULL
  • created_at — TIMESTAMP

workouts

  • id — VARCHAR(36) — Primary key — NOT NULL
  • 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