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