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