kdkd

Tables (12)

account

  • account_seq — BIGINT — Primary key — NOT NULL
  • account_number — VARCHAR(255) — NOT NULL
  • virtual_card — VARCHAR(255)
  • user_uuid — CHAR(36) — Foreign key → user.사용자 UUID — NOT NULL
  • INDEX — `fk_account_user`

account_item

  • account_item_seq — BIGINT — Primary key — NOT NULL
  • account_seq — BIGINT — Foreign key → account.account_seq — NOT NULL
  • place — VARCHAR(200)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • transacted_at — DATETIME — NOT NULL
  • INDEX — `idx_account_item_account`

alert

  • 알림 UUID (alert_uuid) — CHAR(36) — Primary key — NOT NULL
  • 요청 사용자 UUID (sender_uuid) — CHAR(36) — Foreign key → user.사용자 UUID — NOT NULL
  • 응답 사용자 UUID (receiver_uuid) — CHAR(36) — Foreign key → user.사용자 UUID — NOT NULL
  • 알림 내용 (content) — VARCHAR(255) — NOT NULL
  • 생성 일시 (created_at) — DATETIME — NOT NULL

character_list

  • 캐릭터 리스트 (character_seq) — BIGINT — Primary key — NOT NULL
  • 캐릭터 이름 (character_name) — VARCHAR(20) — NOT NULL

file_metadata

  • file_id — BIGINT — Primary key — NOT NULL
  • file_category — ENUM('IMAGES', 'MATERIALS', 'VIDEOS') — NOT NULL
  • related_type — ENUM('BOX', 'USER_PROFILE', 'SIGN') — NOT NULL
  • related_uuid — CHAR(36) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • sequence — INT — NOT NULL
  • file_extension — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_file_related`

loan

  • loan_uuid — CHAR(36) — Primary key — NOT NULL
  • relation_uuid — CHAR(36) — Foreign key → parent_relation.relation_uuid — NOT NULL
  • loan_amount — BIGINT — NOT NULL
  • loan_repayment — BIGINT — NOT NULL
  • loan_date — DATETIME
  • loan_due — DATETIME
  • loan_content — VARCHAR(1000)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_loaned — TINYINT — NOT NULL
  • INDEX — `fk_loan_relation_uuid`

mission

  • mission_uuid — CHAR(36) — Primary key — NOT NULL
  • relation_uuid — CHAR(36) — Foreign key → parent_relation.relation_uuid — NOT NULL
  • mission_title — VARCHAR(20) — NOT NULL
  • mission_content — VARCHAR(255) — NOT NULL
  • reward — BIGINT — NOT NULL
  • status — ENUM('IN_PROGRESS', 'WAITING_REWARD', 'SUCCESS', 'FAILED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • start_at — DATETIME
  • end_at — DATETIME
  • INDEX — `idx_mission_relation`

parent_relation

  • relation_uuid — CHAR(36) — Primary key — NOT NULL
  • parent_uuid — CHAR(36) — Foreign key → user.사용자 UUID — NOT NULL
  • child_uuid — CHAR(36) — Foreign key → user.사용자 UUID — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_pc_parent`
  • INDEX — `idx_pc_child`

save_box

  • box_uuid — CHAR(36) — Primary key — NOT NULL
  • children_uuid — CHAR(36) — Foreign key → user.사용자 UUID — NOT NULL
  • box_name — VARCHAR(255) — NOT NULL
  • saving — BIGINT — NOT NULL
  • remain — BIGINT — NOT NULL
  • expiration_date — DATETIME
  • target — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — `idx_savebox_children`

save_box_item

  • save_box_item_seq — BIGINT — Primary key — NOT NULL
  • box_uuid — CHAR(36) — Foreign key → save_box.box_uuid — NOT NULL
  • box_pay_name — VARCHAR(20) — NOT NULL — 정기 적금/추가적금 이름
  • box_transfer_date — DATETIME — NOT NULL
  • box_amount — BIGINT — NOT NULL — 금액(원)
  • INDEX — `idx_saveboxitem_box`

user

  • 사용자 UUID (user_uuid) — CHAR(36) — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(100) — NOT NULL
  • 생년월일 (birthdate) — DATE
  • 이메일 (email) — VARCHAR(255) — NOT NULL
  • 사용자 구분 (role) — ENUM('PARENTS', 'CHILD') — NOT NULL
  • 제공자 (provider) — ENUM('GOOGLE', 'KAKAO')
  • 제공자 식별 ID (provider_id) — VARCHAR(255)
  • 생성 일시 (created_at) — DATETIME — NOT NULL
  • 수정 일시 (updated_at) — DATETIME — NOT NULL
  • 삭제 일시 (deleted_at) — DATETIME

user_character

  • user_character_seq — INT — Primary key — NOT NULL
  • 사용자 uuid (user_uuid) — CHAR(36) — Foreign key → user.사용자 UUID — NOT NULL
  • 캐릭터 리스트 (character_seq) — BIGINT — Foreign key → character_list.캐릭터 리스트 — NOT NULL
  • 경험치 (experience) — INT — NOT NULL
  • 레벨 (level) — INT — NOT NULL