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