장윤정 수정본
테이블 (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 — 외래 키 → posts.id — NOT NULL
- author_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- company_id — VARCHAR(36) — 외래 키 → companies.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
companies
- id — VARCHAR(36) — 기본 키 — NOT NULL
- name — VARCHAR(200) — NOT NULL
- industry — VARCHAR(100)
- employee_count — INT
- created_at — TIMESTAMP
departments
- id — VARCHAR(36) — 기본 키 — NOT NULL
- company_id — VARCHAR(36) — 외래 키 → companies.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- employee_count — INT
- created_at — TIMESTAMP
employees
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id
- company_id — VARCHAR(36) — 외래 키 → companies.id — NOT NULL
- department_id — VARCHAR(36) — 외래 키 → departments.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- position — VARCHAR(50)
- join_date — DATE
- created_at — TIMESTAMP
posts
- id — BIGINT
- board_id — BIGINT — 외래 키 → boards.id — NOT NULL
- author_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- company_id — VARCHAR(36) — 외래 키 → 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) — 기본 키 — NOT NULL
- user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
- expires — INT — NOT NULL
- data — TEXT
users
- id — VARCHAR(36) — 기본 키 — 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) — 기본 키 — NOT NULL
- company_id — VARCHAR(36) — 외래 키 → companies.id — NOT NULL
- budget_month — DATE — NOT NULL
- total_budget — BIGINT — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
welfare_spendings
- id — VARCHAR(36) — 기본 키 — NOT NULL
- company_id — VARCHAR(36) — 외래 키 → companies.id — NOT NULL
- budget_id — VARCHAR(36) — 외래 키 → welfare_budgets.id — NOT NULL
- workout_id — VARCHAR(36) — 외래 키 → workouts.id
- amount — BIGINT — NOT NULL
- spend_date — DATE — NOT NULL
- created_at — TIMESTAMP
workouts
- id — VARCHAR(36) — 기본 키 — NOT NULL
- employee_id — VARCHAR(36) — 외래 키 → employees.id — NOT NULL
- company_id — VARCHAR(36) — 외래 키 → companies.id — NOT NULL
- department_id — VARCHAR(36) — 외래 키 → 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