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