vendingMachine
Tables (11)
tblarrdellog (5.수불테이블_입출고??)
- idx (인덱스) — int — Primary key — NOT NULL
- tblgoods_idx (외래키1) — int — Foreign key → tblgoods.idx — NOT NULL
- tblmachine_idx (외래키2) — int — Foreign key → tblmachine.idx — NOT NULL
- tblbusiness_idx (외래키3) — int — Foreign key → tblbusiness.idx — NOT NULL
- Field
- Field2
- idx (인덱스2) — int — Foreign key → tblgoods.tblmachine_idx — NOT NULL
tblbusiness (1. 사업자 등록증 테이블)
- idx (인덱스) — int — Primary key — NOT NULL
- Field
- Field2
tblgoods (6.. 상품테이블)
- idx (인덱스) — int — Primary key — NOT NULL
- tblmachine_idx (인덱스2) — int — Foreign key → tblmachine.idx — NOT NULL
- Field
- Field2
- Field3
- Field4
tbllog (로그테이블)
- idx (인덱스) — int — Primary key — NOT NULL
- tblbusiness_idx (외래키1) — int — Foreign key → tblbusiness.idx — NOT NULL
- tblmodel_idx (외래키2) — int — Foreign key → tblmodel.idx — NOT NULL
- tblmachine_idx (외래키3) — int — Foreign key → tblmachine.idx — NOT NULL
- tbluser_useridx (외래키4) — int — Foreign key → tbluser.idx — NOT NULL
- Field
- Field2
- Key — Foreign key — NOT NULL
- idx (인덱스2) — int — Foreign key — NOT NULL
tblmachine (3. 자판기 테이블)
- idx (인덱스) — int — Primary key — NOT NULL
- tbluser_idx (외래키2) — int — Foreign key → tblgoods.idx — NOT NULL
- tblmodel_idx (외래키3) — int — Foreign key → tblmodel.idx — NOT NULL
- Field
- Field2
tblmodel (7. 자판기모델)
- idx (인덱스) — int — Primary key — NOT NULL
- ver (보드바이너리버전) — text
- Field2
tblpayment (구매테이블)
- idx (인덱스) — int — Primary key — NOT NULL
- tblbusiness_idx (외래키3(필요???)) — int — Foreign key → tblbusiness.idx — NOT NULL
- tblgoods_idx (외래키2) — int — Foreign key → tblgoods.idx — NOT NULL
- tblmachine_idx (외래키1) — int — Foreign key → tblmachine.idx — NOT NULL
- tbluser_idx (외래키4) — int — Foreign key → tbluser.idx — NOT NULL
- Field
- Field2
- idx (인덱스2) — int — Foreign key → tblgoods.tblmachine_idx — NOT NULL
tblpointlog (포인트)
- idx (인덱스) — int — Primary key — NOT NULL
- tbluser_idx (외래키) — int — Foreign key → tbluser.idx — NOT NULL
- Field
- Field2
tblrole (사용자 역할)
- idx (인덱스) — int — Primary key — NOT NULL
- Field5
- Field6
tblstock (4.재고테이블)
- idx (인덱스) — int — Primary key — NOT NULL
- tblmachine_idx (외래키2) — int — Foreign key → tblmachine.idx — NOT NULL
- tblbusiness_idx (외래키3) — int — Foreign key → tblbusiness.idx — NOT NULL
- Field
- Field2
- Key — Foreign key — NOT NULL
- idx (인덱스2) — int — Foreign key — NOT NULL
tbluser (2.사용자 테이블)
- idx (인덱스) — int — Primary key — NOT NULL
- tblbusiness_idx (외래키1) — int — Foreign key → tblbusiness.idx — NOT NULL
- tblerole_idx (외래키2) — int — Foreign key → tblrole.idx — NOT NULL
- Field
- Field2