장윤정
테이블 (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 — 외래 키 → posts.id — NOT NULL
- author_id — VARCHAR(255) — 외래 키 → 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) — 외래 키 → companies.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- employee_count — INT
- created_at — TIMESTAMP
employees
- id — VARCHAR(36)
- company_id — VARCHAR(36) — 외래 키 → companies.id — NOT NULL
- department_id — VARCHAR(36) — 외래 키 → 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 — 외래 키 → boards.id — NOT NULL
- author_id — VARCHAR(255) — 외래 키 → 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) — 외래 키 → 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) — 외래 키 → 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