도파민 가계부
테이블 (7)
activity (exchange_rate)
- Key (activity_id) — bigserial — 기본 키 — NOT NULL
- Key (user_id) — bigint — 외래 키 → user.Key — NOT NULL
- Field (activity_type) — varchar(30)
- Field (rate) — numeric(3,2)
crew
- Key (crew_id) — bigserial — 기본 키 — NOT NULL
- Field (name) — varchar(50)
- Field (invite_code) — varchar(10)
- Field (status) — varchar(10)
crew_member
- Key (crew_member_id) — bigserial — 기본 키 — NOT NULL
- Key (user_id) — bigint — 외래 키 → user.Key — NOT NULL
- Key (crew_id) — bigint — 외래 키 → crew.Key — NOT NULL
- Field (joined_date) — date
daily_close
- Key (close_id) — bigserial — 기본 키 — NOT NULL
- Key (user_id) — bigint — 외래 키 → user.Key — NOT NULL
- Field (close_date) — date
- Field (closed_at) — time
earn_record
- earn_id — bigserial — 기본 키 — NOT NULL
- Key (user_id) — bigint — 외래 키 → user.Key — NOT NULL
- Field (activity_id) — bigint
- Field2 (earn_min) — numeric(8,2)
- Field4 (verify_method) — varchar(10)
- Field5 (photo_url(null)) — text
- Field (earn_date) — date
- Field (earn_start) — timestamptz
- Field (earn_end) — timestamptz
spend_record
- spend_id — bigserial — 기본 키 — NOT NULL
- Key (user_id) — bigint — 외래 키 → user.Key — NOT NULL
- spend_date — date
- category — varchar(30)
- duration_min — integer
- spend_start (Field) — timestamptz
- spend_end (Field2) — timestamptz
user
- Key (user_id) — bigserial — 기본 키 — NOT NULL
- Field (email) — varchar(255)
- Field (nickname) — varchar(30)
- Field2 (password) — varchar(255)
- Field3 (kakao_id) — varchar(100) — NOT NULL
- Field4 (streak_days) — Integer
- Field5 (credit_grade) — varchar(20)
- Field6 (create_at) — timestamptz
- Field (weekly_budget_min) — numeric(10, 2)
- Field (conversion_base) — numeric
- Field (converting_activity) — varchar(255)
- Field (converting_unit) — varchar(30)