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