sniperbang

Tables (12)

Untitled (category)

  • Key (id) — int — Primary key — NOT NULL
  • Field (category)

Untitled (rooms)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(100) — 룸 이름
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (guns)

  • Key (id) — int — Primary key — NOT NULL
  • Field (gun_type) — varchar(50) — 총기 타입
  • Field (name) — varchar(100) — 총기 명
  • Field (description) — text — 총기류 관련설명
  • Field (quantity) — int — 재고수량
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled

    Untitled2 (maps)

    • Key (id) — int — Primary key — NOT NULL
    • Field (map_type) — varchar(50) — handgun, rifle, sniper 등...
    • Field (name) — varchar(100) — 맵 이름
    • Field (description) — text — 맵 설명
    • Field (stages) — int — 총 스테이지 수
    • Field (difficulty) — varchar(30) — tutorial, beginner, easy, medium, hard, super hard, impossible
    • Field

    Untitled2 (stages)

      Untitled2 (gears)

      • Key (id) — int — Primary key — NOT NULL
      • Field (gear_type) — varchar(50) — 장비 타입
      • Field (name) — varchar(100) — 장비명
      • Field

      Untitled2 (consumables)

        order

        • Id — int — Primary key — NOT NULL
        • uid — int
        • room_id — int
        • player_count — tinyint
        • title — nvarchar(50)
        • description — ntext
        • order_amount — money
        • discount_amount — money
        • total_amount — money
        • paid_amount — money
        • status — tinyint
        • pay_method — varchar(20)
        • pay_id — int
        • created_at — datetime
        • updated_at — datetime
        • paid_at — datetime

        order_detail

        • Id — int — Primary key — NOT NULL
        • order_id — int
        • item_id — int
        • qty — int
        • amount — money
        • status — tinyint
        • created_at — datetime
        • updated_at — datetime

        payment

        • Id — int — Primary key — NOT NULL
        • pay_method — smallint — 0: 카드 1: 현금 (기타는 계속 추가)
        • req_service_code — varchar(2) — D1 Credit approval D2 Credit Cancel (DCC Credit Cancel) ...
        • req_mobile_phone — varchar(14)
        • req_barcode — varchar(37)
        • req_cc_wcc — varchar(1)
        • req_cc_cardno — varchar(37)
        • req_signature — varchar(1)
        • req_nocard_appcode — varchar(18)
        • req_installment — varchar(2)
        • req_dow — varchar(2)
        • req_point_type — varchar(2)
        • req_customer_id — varchar(13)
        • req_cancel_reason — varchar(1)
        • req_zerotax_amount — varchar(9)
        • req_tax_amount — varchar(9)
        • req_total_amount — varchar(9)
        • req_bonus_code — varchar(4)
        • req_bonus_pin — varchar(16)
        • req_bonus_add1 — varchar(12)
        • req_bonus_add2 — varchar(12)
        • req_approval_no — varchar(12)
        • req_tran_date — varchar(8)
        • req_origin_date — varchar(8)
        • req_cat_id — varchar(80)
        • req_sign_data — nvarchar(2096)
        • req_pr_msg — nvarchar(40)
        • resp_service_code — varchar(2)
        • resp_reject_code — varchar(1)
        • resp_error_code — varchar(2)
        • resp_reject_msg1 — nvarchar(20)
        • resp_reject_msg2 — nvarchar(20)
        • resp_approval_date — varchar(12)
        • resp_customer_infocnt — varchar(2)
        • resp_customer_info1 — nvarchar(80)
        • resp_customer_info2 — nvarchar(80)
        • resp_customer_info3 — nvarchar(80)
        • resp_customer_info4 — nvarchar(80)
        • resp_customer_info5 — nvarchar(80)
        • resp_customer_info6 — nvarchar(80)
        • resp_customer_info7 — nvarchar(80)
        • resp_customer_info8 — nvarchar(80)
        • resp_customer_info9 — nvarchar(80)
        • resp_customer_info10 — nvarchar(80)
        • resp_total_amount — varchar(9)
        • resp_vat — varchar(8)
        • resp_svc_fee — varchar(7)
        • resp_approval_code — varchar(12)
        • resp_issuer_code — varchar(2)
        • resp_purchaser_code — varchar(2)
        • resp_issuer_name — nvarchar(20)
        • resp_purchaser_name — nvarchar(20)
        • resp_system_code — varchar(3)
        • resp_tran_code — varchar(13)
        • resp_issuer_reprcode — varchar(3)
        • resp_purchaser_reprcode — varchar(3)
        • resp_track3_info — nvarchar(30)
        • resp_icard_no — varchar(16)
        • resp_remain_amount — varchar(25)
        • resp_withdrawal_account — varchar(20)
        • … +44

        products (product)

        • Id — int — Primary key — NOT NULL
        • name — nvarchar(255)
        • charge_type — int — 요금타입 0: 기본값, 아이템수량별 1: 플레이어 인원별
        • qty — int
        • Field (stock) — int — 현재고
        • unit_price — float
        • status — tinyint — 0: 판매 1: 중단
        • created_at — datetime
        • updated_at — datetime