kasino

Tables (18)

agent (에이전트)

  • ID (id) — int — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR
  • 포인트보유량 (point) — int
  • 비밀번호 (password) — VARCHAR
  • OTP (otp) — VARCHAR

agent_point_transaction (에이전트 포인트 증감 기록)

  • ID (id) — int — Primary key — NOT NULL
  • 에이전트ID (agentId) — int — Foreign key → agent.ID — NOT NULL
  • 생성날짜(한국) (created_korea_at) — DATE
  • 생성날짜(현지) (created_local_at) — DATE
  • 증감이유 (reason) — int
  • 증가량 (plus) — int
  • 감소량 (minus) — int
  • 생성시간(한국) (created_korea_time) — DATE
  • 생성시간(현지) (created_local_time) — DATE

announcement (공지사항)

  • ID (id) — int — Primary key — NOT NULL
  • 제목 (title) — VARCHAR
  • 내용 (description) — VARCHAR
  • 생성날짜 (created_at) — VARCHAR
  • 수정된날짜 (updated_at) — VARCHAR

button (게임 버튼)

  • ID (id) — int — Primary key — NOT NULL
  • 게임ID (game_id) — int — Foreign key → game.ID — NOT NULL
  • 이름 (name) — VARCHAR
  • 타입 (type) — int

cacher (캐셔)

  • ID (id) — int — Primary key — NOT NULL
  • 현금보유량 (cash) — int
  • 포인트보유량 (point) — int
  • 이메일 (email) — VARCHAR
  • 비밀번호 (password) — VARCHAR
  • OTP (otp) — VARCHAR

cacher_point_transaction (캐셔 포인트 증감 기록)

  • ID (id) — int — Primary key — NOT NULL
  • 캐셔ID (cacher_id) — int — Foreign key → cacher.ID — NOT NULL
  • 생성날짜(한국) (created_korea_at) — DATE
  • 생성날짜(현지) (created_local_at) — DATE
  • 증감이유 (reason) — int
  • 증가량 (plus) — int
  • 감소량 (minus) — int
  • 생성시간(한국) (created_korea_time) — DATE
  • 생성시간(현지) (created_local_time) — DATE

casher_money_transaction (캐셔 현금 증감 기록)

  • ID (id) — int — Primary key — NOT NULL
  • 캐셔ID (cacher_id) — int — Foreign key → cacher.ID — NOT NULL
  • 에이전트ID (agent_id) — int — Foreign key → agent.ID — NOT NULL
  • 생성날짜(한국) (created_korea_at) — DATE
  • 생성날짜(현지) (created_local_at) — DATE
  • 생성시간(한국) (created_korea_time) — DATE
  • 생성시간(현지) (created_local_time) — DATE
  • 증감이유 (reason) — int
  • 증가량 (plus) — int
  • 감소량 (minus) — int

customer_service (질의응답)

  • ID (id) — int — Primary key — NOT NULL
  • PLAYER ID (player_id) — int — Foreign key → player.AgentID — NOT NULL
  • 제목 (title) — VARCHAR
  • 내용 (description) — VARCHAR
  • 상태 (status) — int

frequently_asked_question (FAQ)

  • ID (id) — int — Primary key — NOT NULL
  • 제목 (title) — VARCHAR
  • 내용 (description) — VARCHAR

game (게임)

  • ID (id) — int — Primary key — NOT NULL
  • 이름 (title) — VARCHAR
  • 설명 (description) — VARCHAR
  • 포스터 이미지 (poster_img_url) — VARCHAR

ip_camera (IP카메라)

  • ID (id) — int — Primary key — NOT NULL
  • 기계ID (machine_id) — int — Foreign key → machine.ID — NOT NULL
  • 스트림주소 (url) — VARCHAR

machie_problem_record (기계 문제 이력)

  • ID (id) — int — Primary key — NOT NULL
  • 기계ID (machine_id) — int — Foreign key → machine.ID — NOT NULL
  • 기계종류 (type) — int
  • 메모 (memo) — VARCHAR
  • 에러종류 (error_type) — int

machine (기계)

  • ID (id) — int — Primary key — NOT NULL
  • 게임ID (game_id) — int — Foreign key → game.ID — NOT NULL
  • 상태 (status) — int
  • 돈을 투입했는지 여부 (payment_status) — int

machine_payment_transaction (기계에 투입된 돈)

  • ID (id) — int — Primary key — NOT NULL
  • 기계ID (machine_id) — int — Foreign key → machine.ID — NOT NULL
  • 생성날짜(한국) (created_korea_at) — DATE
  • 생성날짜(현지) (created_local_at) — DATE
  • 금액 (value) — int

player (유저)

  • ID (id) — int — Primary key — NOT NULL
  • AgentID (agent_id) — int — Foreign key → agent.ID — NOT NULL
  • 이메일 (email) — VARCHAR
  • 비밀번호 (password) — VARCHAR
  • 닉네임 (nickname) — VARCHAR
  • 포인트 (point) — int
  • 프로필사진 (profile_img_url) — VARCHAR

player_point_transaction (포인트 증감 기록)

  • ID (id) — int — Primary key — NOT NULL
  • 유저ID (userId) — int — Foreign key → player.ID — NOT NULL
  • 생성날짜(한국) (created_korea_at) — DATE
  • 생성날짜(현지) (created_local_at) — DATE
  • 증감이유 (reason) — int
  • 증가량 (plus) — int
  • 감소량 (minus) — int
  • 생성시간(한국) (created_korea_time) — DATE
  • 생성시간(현지) (created_local_time) — DATE

sms_token (SMS토큰)

  • ID (id) — int — Primary key — NOT NULL
  • playerId (player_id) — int
  • 토큰값 (token) — int

terms_and_condition (이용약관)

  • ID (id) — int — Primary key — NOT NULL
  • 버전 (version) — int
  • 내용 (value) — VARCHAR