키득키득
테이블 (16)
account
- account_seq — bigint — 기본 키 — NOT NULL
- account_number — varbinary(512) — NOT NULL
- virtual_card — varbinary(512)
- virtual_card_cvc — varbinary(512)
- user_uuid — char(36) — 외래 키 → user.user_uuid — NOT NULL
- account_password — varbinary(512) — NOT NULL
- total_use_payment — int
- bank_name — varchar(10) — NOT NULL
account_item
- account_item_seq — bigint — 기본 키 — NOT NULL
- account_seq — bigint — 외래 키 → account.account_seq — NOT NULL
- latitude — double
- longitude — double
- transaction_unique_no — bigint — NOT NULL — 거래고유번호
- category_id — varchar(20) — NOT NULL — 카테고리ID
- category_name — varchar(255) — NOT NULL — 카테고리명
- merchant_id — bigint — NOT NULL — 가맹점ID
- merchant_name — varchar(100) — NOT NULL — 가맹점명
- transacted_at — datetime — NOT NULL — 거래일시(YYYY-MM-DD HH:MM:SS)
- payment_balance — bigint — NOT NULL — 거래금액
alert
- alert_uuid — varchar(36) — 기본 키 — NOT NULL
- sender_uuid — char(36) — 외래 키 → user.user_uuid — NOT NULL
- receiver_uuid — char(36) — 외래 키 → user.user_uuid — NOT NULL
- content — varchar(255) — NOT NULL
- created_at — datetime — NOT NULL
auto_transfer
- auto_transfer_uuid — char(36) — 기본 키 — NOT NULL
- relation_uuid — char(36) — 외래 키 → parent_relation.relation_uuid — NOT NULL — parent_relation.relation_uuid 참조
- transfer_day — int — NOT NULL — 매월 실행 일자 (1~31)
- transfer_time — time — NOT NULL — 실행 시각 (HH:MM:SS)
- amount — bigint — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
character_list
- character_seq — bigint — 기본 키 — NOT NULL
- character_name — varchar(20) — NOT NULL
file_metadata
- file_id — bigint — 기본 키 — NOT NULL
- file_category — enum('IMAGES','MATERIALS','VIDEOS') — NOT NULL
- related_type — enum('BOX','CHARACTER','SIGN','USER_PROFILE') — NOT NULL
- related_uuid — varchar(36) — NOT NULL
- file_name — varchar(255) — NOT NULL
- sequence — int — NOT NULL
- file_extension — varchar(20) — NOT NULL
- created_at — datetime — NOT NULL
lifestyle_merchant
- merchant_id — bigint — 기본 키 — NOT NULL
- merchant_name — varchar(255) — NOT NULL
- subcategory_id — bigint — 외래 키 → lifestyle_subcategory.subcategory_id — NOT NULL
lifestyle_subcategory
- subcategory_id — bigint — 기본 키 — NOT NULL
- subcategory_name — varchar(50) — NOT NULL
loan
- loan_uuid — varchar(36) — 기본 키 — NOT NULL
- relation_uuid — char(36) — 외래 키 → parent_relation.relation_uuid — NOT NULL
- loan_amount — bigint — NOT NULL
- loan_interest — int — NOT NULL
- loan_date — date
- loan_due — date — NOT NULL
- loan_content — varchar(1000)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- is_loaned — bit(1) — NOT NULL
mission
- mission_uuid — varchar(36) — 기본 키 — NOT NULL
- relation_uuid — char(36) — 외래 키 → parent_relation.relation_uuid — NOT NULL
- mission_title — varchar(20) — NOT NULL
- mission_content — varchar(255) — NOT NULL
- reward — bigint — NOT NULL
- status — enum('FAILED','IN_PROGRESS','SUCCESS') — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
- end_at — datetime
parent_relation
- relation_uuid — char(36) — 기본 키 — NOT NULL
- parent_uuid — char(36) — 외래 키 → user.user_uuid — NOT NULL
- child_uuid — char(36) — 외래 키 → user.user_uuid — NOT NULL
- created_at — datetime — NOT NULL
save_box
- box_uuid — char(36) — 기본 키 — NOT NULL
- children_uuid — char(36) — 외래 키 → user.user_uuid — NOT NULL
- box_name — varchar(255) — NOT NULL
- saving — bigint — NOT NULL
- remain — bigint — NOT NULL
- target — bigint — NOT NULL
- status — enum('IN_PROGRESS','SUCCESS') — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
save_box_item
- save_box_item_seq — bigint — 기본 키 — NOT NULL
- box_uuid — char(36) — 외래 키 → save_box.box_uuid — NOT NULL
- box_pay_name — varchar(20) — NOT NULL — 정기 적금/추가적금 이름
- box_transfer_date — datetime — NOT NULL
- box_amount — bigint — NOT NULL — 금액(원)
user
- user_uuid — char(36) — 기본 키 — NOT NULL
- name — varchar(100) — NOT NULL
- birthdate — date
- email — varchar(255) — NOT NULL
- role — enum('CHILD','PARENT') — NOT NULL
- provider — enum('GOOGLE','KAKAO')
- provider_id — varbinary(512)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
- ssafy_user_key — varbinary(512)
user_character
- user_character_seq — int — 기본 키 — NOT NULL
- user_uuid — char(36) — 외래 키 → user.user_uuid — NOT NULL
- character_seq — bigint — 외래 키 → character_list.character_seq — NOT NULL
- experience — int — NOT NULL
- level — int — NOT NULL
user_device_token
- id — bigint — 기본 키 — NOT NULL
- user_uuid — varchar(50) — 외래 키 → user.user_uuid — NOT NULL
- token — varchar(512) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL