CalenderProject
Tables (22)
Attachment
- attachment_id — BIGSERIAL — Primary key — NOT NULL
- schedule_id — BIGSERIAL — Foreign key → Schedule.schedule_id — NOT NULL
- original_name (originam_name) — TEXT — NOT NULL
- object_key — TEXT — NOT NULL
- mime_type — TEXT — NOT NULL
- byte_size — BIGINT — NOT NULL
- position — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT — NOT NULL
- is_img — BOOLEAN — NOT NULL
Calendar
- calendar_id — BIGSERIAL — Primary key — NOT NULL
- owner_id — BIGSERIAL — Foreign key → Member.member_id — NOT NULL
- name — TEXT — NOT NULL
- type — VARCHAR(16) — NOT NULL — 'PERSONAL' 'GROUP'
- visibility — VARCHAR(16) — NOT NULL — 'PRIVATE' 개인에게만 'PROTECTED' 개인/친구 'PUBLIC' 전체
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
Calendar_History
- calendar_history_id — BIGSERIAL — Primary key — NOT NULL
- calendar_id — BIGSERIAL — Foreign key → Calendar.calendar_id — NOT NULL
- actor_id — BIGSERIAL — Foreign key → Member.member_id — NOT NULL
- entity_id — BIGSERIAL
- type — VARCHAR(50)
- change_fields — JSONB
- created_at — TIMESTAMPTZ
Calendar_Member
- calendar_member_id — BIGSERIAL — Primary key — NOT NULL
- calendar_id — BIGSERIAL — Foreign key → Calendar.calendar_id — NOT NULL
- member_id (member_id2) — BIGSERIAL — Foreign key → Member.member_id — NOT NULL
- inviter_id (member_id3) — BIGSERIAL — Foreign key → Member.member_id — NOT NULL
- status — VARCHAR(30) — NOT NULL — INVITED, ACCEPTED, REJECTED
- is_default — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- responded_at — TIMESTAMPTZ
Expense
- expense_id — BIGSERIAL — Primary key — NOT NULL
- schedule_id — BIGSERIAL — Foreign key → Schedule.schedule_id — NOT NULL
- name — VARCHAR(100)
- amount — BIGINT — NOT NULL
- paid_at — TIMESTAMPTZ
- occurrence_date — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- source — VARCHAR(20) — NOT NULL — 'MANUAL' || 'RECEIPT'
- receipt_parse_status — VARCHAR(15) — PENDING SUCCESS FAIL
- parsed_payload — JSONB
Expense_Attachment
- expense_attachment_id — BIGSERIAL — Primary key — NOT NULL
- expense_id — BIGSERIAL — Foreign key → Expense.expense_id — NOT NULL
- attachment_id (attachment_id2) — BIGSERIAL — Foreign key → Attachment.attachment_id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
Expense_Line
- expense_line_id — BIGSERIAL — Primary key — NOT NULL
- expense_id — BIGSERIAL — Foreign key → Expense.expense_id — NOT NULL
- label — VARCHAR(100) — NOT NULL
- quantity — INT — NOT NULL
- unit_amount — BIGINT — NOT NULL
- line_amount — BIGINT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
Expense_Ocr_Task
- ocr_task_id — BIGSERIAL — Primary key — NOT NULL
- attachment_id — BIGSERIAL — Foreign key → Attachment.attachment_id — NOT NULL
- expense_id (expense_id2) — BIGSERIAL — Foreign key → Expense.expense_id — NOT NULL
- schedule_id (schedule_id2) — BIGSERIAL — Foreign key → Schedule.schedule_id — NOT NULL
- status — VARCHAR(20) — NOT NULL — QUEUED RUNNING SUCCESS FAILED
- error_message — TEXT
- raw_response — JSONB
- normalized — JSONB
- request_hash — VARCHAR(64)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
Friendship
- friendship_id — BIGSERIAL — Primary key — NOT NULL
- requester_id — BIGSERIAL — Foreign key → Member.member_id — NOT NULL
- addressee_id — BIGSERIAL — Foreign key → Member.member_id — NOT NULL
- status — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- responded_at — TIMESTAMPTZ — NOT NULL
Kakao_Account (KaKao_Account)
- kakao_account_id (kakao_accout_id) — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGSERIAL — Foreign key → Member.member_id — NOT NULL
- provider_user_id — BIGSERIAL — NOT NULL — 카카오 id
- connected_at — TIMESTAMPTZ — NOT NULL
- refresh_token — TEXT — NOT NULL
- profile_json — JSONB — NOT NULL
Member
- member_id — BIGSERIAL — Primary key — NOT NULL
- name — TEXT — NOT NULL
- email — TEXT
- phone_number — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
- last_login_at — TIMESTAMPTZ
Notification
- notification_id — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGSERIAL — Foreign key → Member.member_id — NOT NULL
- actor_id — BIGSERIAL — Foreign key → Member.member_id — NOT NULL
- type (category) — VARCHAR(100) — EX) 'FRIEND_REQUESTED', 'GROUP_INVITED'
- resource_id — BIGINT
- payload_json — JSONB — NOT NULL — 알림 category 별로 다른 json 형식으로 데이터 반환 ex) {"friendship_id": 11, "requester_id": 7, "requester_name": "홍길동"} {"calendar_id"…
- created_at — TIMESTAMPTZ — NOT NULL
- read_at — TIMESTAMPTZ
- dedupe_key — TEXT — NOT NULL
Place
- place_id — BIGSERIAL — Primary key — NOT NULL
- title — TEXT — NOT NULL
- link — TEXT
- category — VARCHAR(100) — NOT NULL
- description — TEXT
- address — TEXT — 지번주소
- road_address — TEXT — 도로명 주소
- lng — DOUBLE — NOT NULL
- lat — DOUBLE — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- provider — VARCHAR — NOT NULL
- provider_place_key — VARCHAR — NOT NULL
Schedule
- schedule_id — BIGSERIAL — Primary key — NOT NULL
- calendar_id — BIGSERIAL — Foreign key → Calendar.calendar_id — NOT NULL
- title — TEXT — NOT NULL
- memo — TEXT — NOT NULL
- theme — VARCHAR(100) — NOT NULL
- start_at — TIMESTAMPTZ — NOT NULL
- end_at — TIMESTAMPTZ — NOT NULL
- created_by — BIGINT — NOT NULL
- updated_by — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- embedding_dirty — BOOLEAN — NOT NULL
- embedding_synced_at — TIMESTAMPTZ
- embedding_fail_count — INT — NOT NULL
- embedding_last_error — TEXT
- embedding_status — VARCHAR(20) — NOT NULL
Schedule_Link
- schedule_link_id — BIGSERIAL — Primary key — NOT NULL
- schedule_id — BIGSERIAL — Foreign key → Schedule.schedule_id — NOT NULL
- url — TEXT — NOT NULL
- label — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
Schedule_Participant (Schedule_participant)
- schedule_participant_id — BIGSERIAL — Primary key — NOT NULL
- schedule_id (schedule_id2) — BIGSERIAL — Foreign key → Schedule.schedule_id — NOT NULL
- member_id (member_id2) — BIGSERIAL — Foreign key → Member.member_id
- inviter_id (member_id) — BIGSERIAL — Foreign key → Member.member_id — NOT NULL
- name — TEXT — 회원 아닐 시 그냥 이름으로 등록
- invited_at — TIMESTAMPTZ — NOT NULL
- responded_at — TIMESTAMPTZ — NOT NULL
- status — VARCHAR(20) — NOT NULL — INVITED, ACCEPTED, REJECTED
Schedule_Place
- schedule_place_id — BIGSERIAL — Primary key — NOT NULL
- schedule_id — BIGSERIAL — Foreign key → Schedule.schedule_id — NOT NULL
- place_id — BIGSERIAL — Foreign key → Place.place_id
- name — TEXT — 검색 안하고 그냥 이름으로 등록
- position — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
Schedule_Recurrence
- schedule_recurrence_id — BIGSERIAL — Primary key — NOT NULL
- schedule_id — BIGSERIAL — Foreign key → Schedule.schedule_id — NOT NULL
- freq — VARCHAR(50) — NOT NULL
- interval_count — INT
- by_day — TEXT[] — NOT NULL
- by_monthday — INT[]
- by_month — INT[] — NOT NULL
- until — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
Schedule_Recurrence_Exception
- exception_id — BIGSERIAL — Primary key — NOT NULL
- schedule_recurrence_id — BIGSERIAL — Foreign key → Schedule_Recurrence.schedule_recurrence_id — NOT NULL
- exception_date — DATE — NOT NULL
Schedule_Reminder
- schedule_reminder_id — BIGSERIAL — Primary key — NOT NULL
- schedule_id — BIGSERIAL — Foreign key → Schedule.schedule_id — NOT NULL
- minutes_before — INTEGER — NOT NULL
Schedule_Todo
- schedule_todo_id — BIGSERIAL — Primary key — NOT NULL
- schedule_id (schedule_id2) — BIGSERIAL — Foreign key → Schedule.schedule_id — NOT NULL
- content — TEXT — NOT NULL
- is_done — BOOLEAN — NOT NULL
- order_no — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
schedule_embedding
- schedule_id — BIGSERIAL — Foreign key → Schedule.schedule_id — NOT NULL
- embedding — vector(384) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- upadated_at (updated_at) — TIMESTAMPTZ — NOT NULL