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