Kiosk

Tables (6)

ItemTable (제품)

  • idx (기본키) — int — Primary key — NOT NULL
  • category (카테고리) — varchar(100) — Foreign key → categoryTable.idx — NOT NULL
  • itemName (제품명) — varchar(100)
  • price (제품가격) — int
  • content (제품설명) — varchar(1000)
  • regdate (등록일) — date
  • on/off (사용유무) — varchar(1)

TemporaryTable(Client) (장바구니)

  • idx (기본키) — int — Primary key — NOT NULL
  • itemNumber (제품 순번) — varchar(10)
  • itemName (제품명) — varchar(100)
  • itemCount (수량) — int
  • payment (금액) — int
  • orderNumber (주문 순번) — int
  • regdate (결제일) — date

TemporaryTable(Server) (TCP/IP DataTable)

  • idx (기본키) — int — Primary key — NOT NULL
  • itemNumber (제품 순번) — varchar(10)
  • itemName (제품명) — varchar(100)
  • itemCount (수량) — int
  • payment (금액) — int
  • orderNumber (주문 순번) — int
  • regdate (결제일) — date

categoryTable (카테고리)

  • idx (기본키) — int — Primary key — NOT NULL
  • cg_code (식별 코드) — varchar(5)
  • cg_name (카테고리 명) — varchar(100)
  • regdate (등록일) — date

optionTable (제품 옵션)

  • idx (기본키) — int — Primary key — NOT NULL
  • optionName (옵션 명) — varchar(100)
  • option_value (옵션 가격) — varchar(30)
  • regdate (등록일) — date
  • on/off (사용유무) — varchar(1)

orderTable (결제)

  • idx (기본키) — int — Primary key — NOT NULL
  • itemNumber (제품 순번) — varchar(10)
  • itemName (제품명) — varchar(100)
  • itemCount (수량) — int
  • payment (금액) — int
  • orderNumber (주문 순번) — int
  • regdate (결제일) — date