Shop

Tables (18)

ACCOUNT (Untitled8)

  • USER_IDX (key) — long — Primary key — NOT NULL
  • USER_ID (Field) — string
  • USER_PASSWORD (Field2) — string
  • ROLE (Field3) — bit
  • CREATE_DATE (Field4) — dateTime
  • DELETE_DATE (Field6) — dateTime
  • LAST_LOGIN_DATE (Field7) — dateTime
  • TERMS_AGREE_DATE (Field5) — dateTime

ADMIN (Untitled7)

  • ADMIN_IDX (Key) — long — Primary key — NOT NULL
  • ADMIN_ID (Field) — string
  • ADMIN_PASSWORD (Field2) — string
  • ADMIN_ROLE_NAME (Field3) — string
  • ADMIN_ENABLED (Field4) — string

BILL_KEY (BillKey)

  • BILL_KEY (Key) — string — Primary key — NOT NULL
  • ISSUE_DATE (Field) — dateTime
  • CANCEL_DATE (Field2) — dateTime
  • UPDATE_DATE (Field4) — dateTime

BOOK (Untitled2)

  • BOOK_IDX (Key) — long — Primary key — NOT NULL
  • CATG_IDX (Key2) — long — Foreign key → CATEGORY.CATG_IDX — NOT NULL
  • BOOK_TITLE (Field) — string
  • BOOK_IMG (Field2) — string
  • BOOK_AUTHOR (Field3) — string
  • BOOK_PRICE (Field4) — decimal
  • BOOK_PUBLISHER (Field5) — string
  • BOOK_DESC (Field6) — string
  • BOOK_PUBDATE (Field7) — dateTime
  • BOOK_ISBN (Field9) — string
  • VERSION_ID (Key3) — long — Foreign key → ShopVersion.VESION_ID — NOT NULL

BOOK_COUNT (Untitled11)

  • BOOK_IDX (Key) — long — Primary key — NOT NULL
  • TOTAL_COUNT (Field) — int
  • MONTH_COUNT (Field2) — int

BOOK_COUNT_HISTORY (Untitled12)

  • BOOK_IDX (Key) — long — Primary key — NOT NULL
  • HISTORY (Key2) — long — Primary key — NOT NULL
  • VIEW_COUNT (Field2) — int

CANCEL (Cancel)

  • BOOK_IDX (Key1) — long — Foreign key → PURCHASE_BOOK.BOOK_IDX — NOT NULL
  • PURCHASE_ORDER_IDX (Key2) — long — Foreign key → PURCHASE_BOOK.PURCHASE_ORDER_IDX — NOT NULL
  • PRICE (Field) — decimal
  • REASON (Field2) — string
  • COUNT (Field3) — int
  • RETURN_CODE (Field4) — int
  • CREATE_DATE (Field5) — dateTime
  • UPDATE_DATE (Field6) — dateTime
  • BILL_KEY (Key4) — string — Foreign key → BILL_KEY.BILL_KEY — NOT NULL

CART (Untitled)

  • BOOK_IDX (Key2) — long — Foreign key → BOOK.BOOK_IDX — NOT NULL
  • USER_IDX (key) — long — Foreign key → ACCOUNT.USER_IDX — NOT NULL
  • CREATE_DATE (Field) — dateTime
  • BOOK_IMG (Field2) — string
  • BOOK_PRICE (Field3) — string
  • BOOK_TITLE (Field4) — string
  • BOOK_QTY (Field5) — string

CATEGORY (Untitled3)

  • CATG_IDX (Key) — long — Primary key — NOT NULL
  • CATG_NAME (Field) — string

EMAIL_QUESTION (Untitled10)

  • EMAIL_IDX (Key) — long — Primary key — NOT NULL
  • NAME (Field) — string
  • SUBJECT (Field2) — string
  • EMAIL_ADDRESS (Field3) — string
  • CONTENT (Field4) — string

EXPAND_BOOK_COUNT_HISTORY (Untitled13)

  • BOOK_IDX (Key) — long — Primary key — NOT NULL
  • HISTORY (Key2) — long — Primary key — NOT NULL
  • VIEW_COUNT (Field2) — int
  • BUY_COUNT (Field3) — int
  • CART_COUNT (Field4) — int

PURCHASE_BOOK (PurchaseBook)

  • BOOK_IDX (Key) — long — Primary key — NOT NULL
  • PURCHASE_ORDER_IDX (Key3) — long — Foreign key → PURCHASE_ORDER.PURCHASE_ORDER_IDX — NOT NULL
  • PRICE (Field) — decimal
  • STATE_CODE (Field2) — int
  • NAME (Field3) — string
  • COUNT (Field4) — int
  • IMAGE_PATH (Field6) — string
  • CREATE_DATE (Field7) — dateTime
  • UPDATE_DATE (Field8) — dateTime
  • BILL_KEY (Key2) — string — Foreign key → BILL_KEY.BILL_KEY — NOT NULL

PURCHASE_ORDER (PurchaseOrder)

  • PURCHASE_ORDER_IDX (Key) — long — Primary key — NOT NULL
  • STATE_CODE (Field2) — int
  • DELIVERY_ADDRESS (Field3) — string
  • ORDER_DATE (Field4) — dateTime
  • UPDATE_DATE (Field5) — dateTime
  • BILL_KEY (Key2) — string — Foreign key → BILL_KEY.BILL_KEY — NOT NULL
  • USER_IDX (Field) — long

PURCHASE_PAYMENT (PurchasePayment)

  • PURCHASE_ORDER_IDX (Key1) — long — Foreign key → PURCHASE_ORDER.PURCHASE_ORDER_IDX — NOT NULL
  • TOTAL_PRICE (Field) — decimal
  • SHIPPING_PRICE (Field8) — decimal
  • PAYMENT_CODE (Field2) — int
  • RECEIVER_NAME (Field3) — string
  • RECEIVER_PHONE (Field4) — string
  • DELIVERY_COMMENT (Field5) — string
  • CREATE_DATE (Field6) — dateTime
  • UPDATE_DATE (Field7) — dateTime

REVIEW (Untitled5)

  • USER_IDX (key) — long — Foreign key → ACCOUNT.USER_IDX — NOT NULL
  • BOOK_IDX (Key2) — long — Foreign key → BOOK.BOOK_IDX — NOT NULL
  • REIVEW_TITLE (Field) — string
  • REVIEW_CONTENT (Field2) — string
  • REVIEW_SCORE (Field3) — int
  • CREATE_DATE (Field4) — dateTime
  • UPDATE_DATE (Field5) — dateTime

STATISTICS (Untitled6)

  • STAT_IDX (Key2) — long — Primary key — NOT NULL
  • SALE_PRICE (Field) — decimal
  • SALE_DATE (Field2) — dateTime
  • USER_COUNT (Field3) — long

ShopVersion (Untitled9)

  • VESION_ID (Key) — string — Primary key — NOT NULL
  • FILE_PATH (Field) — string
  • CREATE_DATE (Field2) — dateTime
  • UPDATE_DATE (Field3) — dateTime

USERS (Untitled4)

  • USER_IDX (key) — long — Foreign key → ACCOUNT.USER_IDX — NOT NULL
  • USER_NAME (Field3) — string
  • USER_SEX (Field4) — int
  • USER_AGE (Field5) — int
  • USER_PHONE (Field6) — string
  • USER_ADDRES (Field7) — string
  • CREATE_DATE (Field9) — dateTime
  • UPDATE_DATE (Field10) — dateTime