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