11

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

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 — boolean — 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 — boolean — NOT NULL
  • date — date

check_record

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

comment

  • id — uuid — Primary key — NOT NULL
  • comment — varchar(255) — archar(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_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)

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 — boolean — NOT NULL
  • created_at — timestamp(6) — NOT NULL

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 — integer — 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 — smallint
  • birth_year — integer — NOT NULL
  • birth_month — integer — NOT NULL
  • birth_day — integer — NOT NULL