카카오 온보딩
테이블 (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