키득키득

테이블 (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