카카오 온보딩

테이블 (5)

business_trip

  • trip_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • trip_date — DATE — NOT NULL
  • transport_type — VARCHAR(20) — NOT NULL
  • departure — VARCHAR(100)
  • destination — VARCHAR(100)
  • distance_km — DOUBLE
  • carbon_emissions — DOUBLE
  • status — VARCHAR(20)

carbon_policy

  • policy_id — BIGINT
  • transport_name — VARCHAR(20) — NOT NULL
  • emission_factor — DOUBLE — NOT NULL

commute_record

  • commute_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • commute_date — DATE — NOT NULL
  • transport_type — VARCHAR(20) — NOT NULL
  • carbon_emissions — DOUBLE — NOT NULL

department

  • dept_id — BIGINT
  • dept_name — VARCHAR(50) — NOT NULL
  • parent_id — BIGINT

member

  • member_id — BIGINT
  • dept_id — BIGINT — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • role — VARCHAR(20) — NOT NULL