carryporter-refactoring

Tables (5)

missions (미션)

  • mission_id (미션 pk) — bigint — Primary key — NOT NULL
  • user_id (사용자 fk) — bigint — Foreign key → users.user_id
  • robot_id (로봇 fk) — bigint — Foreign key → robots.robot_id
  • mission_status (미션 상태) — enum('CREATED', 'ASSIGNED', 'DISPATCHED', 'ARRIVED', 'RETURNING', 'FINISHED', 'FAILED') — NOT NULL
  • created_at (최초 생성일) — datetime — NOT NULL
  • updated_at (최종 수정알) — datetime — NOT NULL

notifications (알림)

  • notification_id (알림 pk) — Primary key — NOT NULL
  • user_id (사용자 fk) — bigint — Foreign key → users.user_id
  • mission_id (미션 fk) — bigint — Foreign key → missions.mission_id
  • event_type (이밴트 타입) — varchar(50) — NOT NULL
  • message (알림 메시지) — varchar(255) — NOT NULL
  • failure_code (실패 코드) — varchar(50)
  • created_at (최초 생성일) — datetime — NOT NULL
  • updated_at (최종 수정일) — datetime — NOT NULL

processed_robot_events (처리된 로봇 이벤트)

  • processed_robot_event_id (처리된 로봇 이벤트 pk) — bigint — Primary key — NOT NULL
  • robot_event_id (로봇 event id) — varchar(255) — NOT NULL
  • robot_mac_address (로봇 맥주소) — varchar(255) — NOT NULL
  • created_at (최초 생성일) — datetime — NOT NULL
  • updated_at (최종 수정일) — datetime — NOT NULL

robots (로봇)

  • robot_id (로봇 pk) — bigint — Primary key — NOT NULL
  • mac_address (로봇 맥 주소) — varchar(255) — NOT NULL — unique
  • robot_status (로봇 상태) — enum('IDLE', 'BUSY', 'OFFLINE') — NOT NULL
  • created_at (최초 생성일) — datetime — NOT NULL
  • updated_at (최종 수정일) — datetime — NOT NULL

users (사용자)

  • user_id (사용자 pk) — bigint — Primary key — NOT NULL
  • username (사용자 id) — varchar(50) — NOT NULL — unique
  • password (비밀번호) — varchar(255) — NOT NULL
  • refresh_token (리프레시 토큰 값) — varchar(512)
  • created_at (최초 생성일) — datetime — NOT NULL
  • updated_at (최종 수정일) — datetime — NOT NULL