도파민 가계부

테이블 (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)