ㄴㅇㅀㄴㅇ
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