AI
Tables (10)
event_targets
- id — BIGINT — Primary key — NOT NULL
- event_id — BIGINT — Foreign key → events.id — NOT NULL
- scope — VARCHAR(30) — NOT NULL
- target_user_id — BIGINT — Foreign key → users.id
- target_organization_unit_id — BIGINT — Foreign key → organization_units.id
- created_at — TIMESTAMP — NOT NULL
events
- id — BIGINT — Primary key — NOT NULL
- creator_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- start_at — TIMESTAMP — NOT NULL
- end_at — TIMESTAMP — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- all_day — BOOLEAN — NOT NULL
job_grades
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- code — VARCHAR(50) — NOT NULL
- level — INT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
meeting_rooms
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255)
- floor — VARCHAR(50)
- capacity — INT — NOT NULL
- equipment_info — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
organization_unit_closure
- ancestor_id — BIGINT — Foreign key → organization_units.id — NOT NULL
- descendant_id — BIGINT — Foreign key → organization_units.id — NOT NULL
- depth — INT — NOT NULL
organization_units
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → organization_units.id
- name — VARCHAR(100) — NOT NULL
- code — VARCHAR(50) — NOT NULL
- type — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
positions
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- code — VARCHAR(50) — NOT NULL
- level — INT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
room_reservations
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → meeting_rooms.id — NOT NULL
- event_id — BIGINT — Foreign key → events.id — NOT NULL
- reserver_id — BIGINT — Foreign key → users.id — NOT NULL
- start_at — TIMESTAMP — NOT NULL
- end_at — TIMESTAMP — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_organization_memberships
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- organization_unit_id — BIGINT — Foreign key → organization_units.id — NOT NULL
- job_grade_id — BIGINT — Foreign key → job_grades.id
- position_id — BIGINT — Foreign key → positions.id
- membership_type — VARCHAR(30) — NOT NULL
- is_primary — BOOLEAN — NOT NULL
- started_at — DATE — NOT NULL
- ended_at — DATE
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- employee_no — VARCHAR(50) — NOT NULL
- login_id — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(30)
- status — VARCHAR(30) — NOT NULL
- last_login_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL