ㄴㅇㅀㄴㅇ

Tables (12)

account

  • account_seq — bigint — Primary key — NOT NULL
  • account_number — varbinary(512) — NOT NULL
  • virtual_card — varbinary(512)
  • virtual_card_cvc — varbinary(512)
  • user_uuid — char(36) — Foreign key → user.user_uuid — NOT NULL
  • account_password — varbinary(512) — NOT NULL
  • total_use_payment — int

account_item

  • account_item_seq — bigint — Primary key — NOT NULL
  • account_seq — bigint — Foreign key → 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) — Primary key — NOT NULL
  • sender_uuid — char(36) — Foreign key → user.user_uuid — NOT NULL
  • receiver_uuid — char(36) — Foreign key → user.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','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

loan

  • loan_uuid — varchar(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 — bit(1) — NOT NULL

mission

  • mission_uuid — varchar(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('FAILED','IN_PROGRESS','SUCCESS','WAITING_REWARD') — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • start_at — datetime
  • end_at — datetime

parent_relation

  • relation_uuid — char(36) — Primary key — NOT NULL
  • parent_uuid — char(36) — Foreign key → user.user_uuid — NOT NULL
  • child_uuid — char(36) — Foreign key → user.user_uuid — NOT NULL
  • created_at — datetime — NOT NULL

save_box

  • box_uuid — char(36) — Primary key — NOT NULL
  • children_uuid — char(36) — Foreign key → user.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

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 — 금액(원)

user

  • user_uuid — char(36) — Primary key — 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 — Primary key — NOT NULL
  • user_uuid — char(36) — Foreign key → user.user_uuid — NOT NULL
  • character_seq — bigint — Foreign key → character_list.character_seq — NOT NULL
  • experience — int — NOT NULL
  • level — int — NOT NULL