ㅁㅁㅁ

Tables (17)

category

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → users.id
  • title — varchar(255)
  • description — text
  • record_type — varchar(255)
  • visibility — varchar(255) — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • CHECKLIST::character — varying
  • TEXT::character — varying
  • TIME::character — varying
  • NUMBER::character — varying
  • EXPENSE::character — varying)::text)))
  • PUBLIC::character — varying)::text)))

category_like

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → users.id
  • category_id — uuid — Foreign key → category.id
  • created_at — timestamp(6)

chat_message

  • id — uuid — Primary key — NOT NULL
  • chat_room_id — uuid — Foreign key → chat_room.id — NOT NULL
  • sender_id — uuid — Foreign key → users.id — NOT NULL
  • content — text — NOT NULL
  • is_read — bool — NOT NULL
  • created_at — timestamp(6) — NOT NULL

chat_room

  • id — uuid — Primary key — NOT NULL
  • user1_id — uuid — Foreign key → users.id — NOT NULL
  • user2_id — uuid — Foreign key → users.id — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • last_message_at — timestamp(6)

check_list_record

  • id — uuid — Primary key — NOT NULL
  • category_id — uuid — Foreign key → category.id
  • todo — varchar(255)
  • success — bool — NOT NULL
  • date — date

check_record

  • id — uuid — Primary key — NOT NULL
  • category_id — uuid — Foreign key → category.id
  • success — bool — NOT NULL
  • date — date

comment

  • id — uuid — Primary key — NOT NULL
  • comment — varchar(255)
  • parent_id — uuid — Foreign key → comment.id
  • category_id — uuid — Foreign key → category.id
  • user_id — uuid — Foreign key → users.id
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6)

expense_record

  • id — uuid — Primary key — NOT NULL
  • category_id — uuid — Foreign key → category.id
  • amount — float8 — NOT NULL
  • expense_type — varchar(255)
  • payment_method — varchar(255)
  • merchant — varchar(255)
  • memo — varchar(255)
  • date — date
  • EXPENSE::character — varying)::text)))
  • CARD::character — varying
  • TRANSFER::character — varying
  • OTHER::character — varying)::text)))

expense_record_tag

  • id — uuid — Primary key — NOT NULL
  • expense_record_id — uuid — Foreign key → expense_record.id
  • expense_tag_id — uuid — Foreign key → expense_tag.id

expense_tag

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → users.id
  • name — varchar(255)

friendship

  • id — uuid — Primary key — NOT NULL
  • requester_id — uuid — Foreign key → users.id — NOT NULL
  • receiver_id — uuid — Foreign key → users.id — NOT NULL
  • status — varchar(255) — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6)
  • ACCEPTED::character — varying
  • REJECTED::character — varying
  • BLOCKED::character — varying)::text)))

notification

  • id — uuid — Primary key — NOT NULL
  • receiver_id — uuid — Foreign key → users.id — NOT NULL
  • sender_id — uuid — Foreign key → users.id — NOT NULL
  • type — varchar(255) — NOT NULL
  • data — jsonb
  • read — bool — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • LIKE::character — varying
  • REPLY::character — varying
  • FRIEND_REQUEST::character — varying
  • FRIEND_ACCEPT::character — varying
  • CHAT_MESSAGE::character — varying)::text)))

number_record

  • id — uuid — Primary key — NOT NULL
  • category_id — uuid — Foreign key → category.id
  • number — float8 — NOT NULL
  • date — date

text_record

  • id — uuid — Primary key — NOT NULL
  • category_id — uuid — Foreign key → category.id — NOT NULL
  • title — varchar(255)
  • text — text
  • date — date

text_record_image

  • id — uuid — Primary key — NOT NULL
  • text_record_id — uuid — Foreign key → text_record.id — NOT NULL
  • image_url — varchar(255)
  • display_order — int4 — NOT NULL

time_record

  • id — uuid — Primary key — NOT NULL
  • category_id — uuid — Foreign key → category.id
  • time — time(6)
  • date — date

users

  • id — uuid — Primary key — NOT NULL
  • email — varchar(255)
  • username — varchar(255)
  • nickname — varchar(255)
  • password — text
  • profile_image_url — varchar(255)
  • title — varchar(255)
  • description — text
  • authority — int2
  • birth_year — int4 — NOT NULL
  • birth_month — int4 — NOT NULL
  • birth_day — int4 — NOT NULL