wakuwaku-admin

테이블 (18)

TB_ATTACHMENT

  • attachment_id — BIGINT — 기본 키 — NOT NULL
  • post_id — BIGINT — NOT NULL
  • file_name — VARCHAR(255)
  • file_path — VARCHAR(500)
  • file_size — BIGINT
  • post_id (post_id2) — BIGINT — 외래 키 → TB_POST.post_id — NOT NULL

TB_BOARD

  • board_id — BIGINT — 기본 키 — NOT NULL
  • board_name — VARCHAR(100) — NOT NULL
  • board_type — VARCHAR(50)

TB_COMMENT

  • comment_id — BIGINT — 기본 키 — NOT NULL
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • user_id (user_id3) — BIGINT — 외래 키 → TB_USER.user_id — NOT NULL
  • post_id (post_id2) — BIGINT — 외래 키 → TB_POST.post_id — NOT NULL

TB_CRANE

  • crane_id — BIGINT — 기본 키 — NOT NULL
  • p1_value — INT
  • p2_value — INT
  • p3_value — INT
  • note — TEXT
  • device_id (device_id2) — BIGINT — 외래 키 → TB_DEVICE.기기 ID — NOT NULL

TB_DEVICE

  • 기기 ID (device_id) — BIGINT — 기본 키 — NOT NULL
  • mgmt_id — VARCHAR(100) — NOT NULL — 기기관리번호
  • device_name — VARCHAR(255)
  • device_type — VARCHAR(50)
  • serial_no — VARCHAR(100)
  • location_desc — VARCHAR(255) — 설치 위치 상세
  • terminal_no — VARCHAR(100) — 카드 단말기 번호
  • module_id — VARCHAR(100)
  • play_price — INT
  • status — VARCHAR(20) — 준비중/운영중/중단
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • store_id (store_id2) — BIGINT — 외래 키 → 매장.store_id — NOT NULL

TB_POST

  • post_id — BIGINT — 기본 키 — NOT NULL
  • board_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • created_at — DATETIME — NOT NULL
  • user_id (user_id2) — BIGINT — 외래 키 → TB_USER.user_id — NOT NULL
  • board_id (board_id2) — BIGINT — 외래 키 → TB_BOARD.board_id — NOT NULL

TB_PRODUCT

  • product_id — BIGINT — 기본 키 — NOT NULL
  • product_code — VARCHAR(100) — NOT NULL
  • product_name — VARCHAR(255) — NOT NULL
  • alias — VARCHAR(255)
  • image_url — VARCHAR(500)
  • cost_price — INT
  • status — ENUM — 판매중/중지
  • created_at — DATETIME — NOT NULL

TB_SALES_HISTORY

  • history_id — BIGINT — 기본 키 — NOT NULL
  • sales_id — BIGINT — NOT NULL
  • device_id — VARCHAR(100)
  • daily_coin — INT
  • prize_out — INT
  • updated_at — DATETIME — NOT NULL
  • user_id — BIGINT — 외래 키 → TB_USER.user_id — NOT NULL

TB_SALES_INPUT

  • sales_id — BIGINT — 기본 키 — NOT NULL
  • device_id — VARCHAR(100) — NOT NULL
  • store_name — VARCHAR(255)
  • daily_coin — INT
  • product_code — VARCHAR(100)
  • prize_out — INT
  • cost_price — INT — NOT NULL
  • play_price — INT — NOT NULL
  • sales_date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • user_id (user_id2) — BIGINT — 외래 키 → TB_USER.user_id — NOT NULL

TB_SALES_REPORT

  • report_id — BIGINT — 기본 키 — NOT NULL
  • sales_id (sales_id2) — BIGINT — 외래 키 → TB_SALES_INPUT.sales_id — NOT NULL
  • device_id — VARCHAR(100)
  • store_name — VARCHAR(255)
  • sales_date — DATE
  • net_daily_coin — INT
  • net_prize_out — INT
  • previous_daily_coin — INT
  • previous_prize_out — INT
  • play_price — DECIMAL(18, 2)
  • cost_price — DECIMAL(18, 2)
  • created_at — DATETIME — NOT NULL

TB_SLOT

  • mapping_id (slot_id) — BIGINT — 기본 키 — NOT NULL
  • slot_no — INT — NOT NULL
  • created_at — DATE
  • updated_at (Field) — DATE
  • slot_name — VARCHAR
  • 기기 ID (device_id) — BIGINT — 외래 키 → TB_DEVICE.기기 ID — NOT NULL

TB_SLOT_PRODUCT_MAPPING (TB_DEVICE_SLOT_MAPPING)

  • mapping_id — BIGINT — 기본 키 — NOT NULL
  • slot_id — BIGINT — NOT NULL
  • product_id — BIGINT
  • Field2

TB_STOCK

  • stock_id — BIGINT — 기본 키 — NOT NULL
  • store_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • warehouse_qty — INT — NOT NULL
  • device_qty — INT — NOT NULL
  • updated_at — DATETIME

TB_USER

  • user_id — BIGINT — 기본 키 — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255)
  • phone — VARCHAR(50)
  • managed_store_id — BIGINT
  • note — TEXT
  • created_at — DATETIME — NOT NULL
  • role_id — BIGINT — 외래 키 → TB_USER_ROLE.role_id — NOT NULL

TB_USER_ROLE

  • role_id — BIGINT — 기본 키 — NOT NULL
  • role_name — ENUM — SUPER_ADMIN, ADMIN, OWNER, STAFF, MANAGER

매장 (TB_STORE)

  • store_id — BIGINT — 기본 키 — NOT NULL
  • 브랜드 이름 (brand_name) — VARCHAR(100)
  • country — VARCHAR(50)
  • store_name — VARCHAR(255) — NOT NULL
  • store_code — VARCHAR(50) — NOT NULL
  • contract_type — VARCHAR(20) — 직영/가맹
  • address — VARCHAR(500)
  • contract_start_date — DATE
  • contract_end_date — DATE
  • pay_currency — VARCHAR(10) — 결제 통화
  • receive_currency — VARCHAR(10) — 수취 통화
  • contractor_name — VARCHAR(100)
  • operator_name — VARCHAR(100)
  • business_no — VARCHAR(50)
  • phone — VARCHAR(50)
  • email — VARCHAR(255)
  • mall_member_id — VARCHAR(100) — 폐쇄몰 ID
  • status — ENUM — 준비중/운영중/중단
  • note — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

발주 (TB_PURCHASE_ORDER)

  • Key — 기본 키 — NOT NULL

아두이노 (TB_ARDUINO)

  • arduino_id — 기본 키 — NOT NULL
  • 아두이노 식별 ID (module_id)
  • 온라인 연결 상태 (is_online)
  • 마지막 통신 시간 (last_seen_at)
  • 연결된 기기 ID (device_id) — BIGINT — 외래 키 → TB_DEVICE.기기 ID — NOT NULL