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