moiemeasy
Tables (15)
attendant
- attendant_id — BIGINT
- create_at — DATETIME(6)
- update_at — DATETIME(6)
- schedule_id — BIGINT
- user_id — BIGINT
board
- board_id — BIGINT
- create_at — DATETIME(6)
- update_at — DATETIME(6)
- content — LONGTEXT
- notice — BIT
- title — VARCHAR(255)
- user_id — BIGINT
category
- category_id — BIGINT
- category_type — ENUM('REVENUE','EXPENSE')
chat_messages
- id — BIGINT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- content — VARCHAR(2048)
- message_type — ENUM('TEXT','IMAGE')
- sender_type — ENUM('USER','SYSTEM')
- sender_id — BIGINT
- chat_room_id — BIGINT
chat_rooms
- chat_room_id — BIGINT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- user_id — BIGINT
- name — VARCHAR(255)
invitation
- id — BIGINT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- moim_id — BIGINT
- token — VARCHAR(255)
- status — ENUM('ACTIVE','EXPIRED')
moim
- moim_id — BIGINT
- moim_account_number — VARCHAR(255)
- moim_account_amount — DOUBLE
- create_at — DATETIME(6)
- update_at — DATETIME(6)
- moim_name — VARCHAR(100)
notification
- notification_id — BIGINT
- create_at — DATETIME(6)
- update_at — DATETIME(6)
- body — VARCHAR(255)
- header — VARCHAR(255)
- moim_id — BIGINT
- user_id — BIGINT
refresh_tokens
- id — BIGINT
- create_at — DATETIME(6)
- expire_at — DATETIME(6)
- token — VARCHAR(255)
- status — ENUM('ACTIVE','EXPIRED')
request
- request_id — BIGINT
- create_at — DATETIME(6)
- update_at — DATETIME(6)
- details — VARCHAR(255)
- request_type — ENUM('JOIN','WITHDRAW')
- status — ENUM('PENDING','ACCEPTED','REJECTED')
- moim_id — BIGINT
- user_id — BIGINT
roles
- role_id — BIGINT
- role_name — VARCHAR(25) — NOT NULL
schedule
- schedule_id — BIGINT
- create_at — DATETIME(6)
- update_at — DATETIME(6)
- description — VARCHAR(255)
- end_date_time — DATETIME(6)
- is_all_day — BIT
- location — VARCHAR(255)
- schedule_type — VARCHAR(255)
- start_date_time — DATETIME(6)
- user_id — BIGINT
settlement
- settlement_id — BIGINT
- create_at — DATETIME(6)
- update_at — DATETIME(6)
- amount — DOUBLE
- image_url — VARCHAR(255)
- settlement_status — ENUM('WAITING','APPROVED','REJECTED')
- user_id — BIGINT
transaction
- transaction_id — BIGINT
- create_at — DATETIME(6)
- update_at — DATETIME(6)
- amount — DOUBLE
- category_name — VARCHAR(255)
- deposit_name — VARCHAR(255)
- moim_account_number — VARCHAR(255)
- transaction_type — ENUM('DEPOSIT','WITHDRAW')
- withdrawal_name — VARCHAR(255)
- user_id — BIGINT
users
- user_id — BIGINT
- create_at — DATETIME(6)
- update_at — DATETIME(6)
- user_account_number — VARCHAR(255)
- address — VARCHAR(255)
- last_notification_check — DATETIME(6)
- moim_id — BIGINT
- password — VARCHAR(255)
- phone — VARCHAR(25)
- profile_image — VARCHAR(255)
- user_name — VARCHAR(100)
- role_id — BIGINT