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