18

Tables (6)

manage products (Untitled4)

  • productNUMBER (porduct_NUMBER) — number — Foreign key → products info.productNUMBER — NOT NULL
  • regDATE (reg_DATE) — datetime
  • modifyDATE (modify_DATE) — datetime
  • stock NUM (stock_NUM) — number
  • deleteDATE (delete_DATE) — datetime
  • sold NUM (sold_NUM) — number
  • order NUM (order_NUM) — number
  • Field

manager info (Untitled3)

  • managerID (manager_ID) — varchar2(20) — Primary key — NOT NULL
  • productNUMBER (porduct_NUMBER) — number — Foreign key → manage products.productNUMBER — NOT NULL
  • managerPASSWORD (manager_PASSWORD) — varchar2(20)
  • managerNUMBER (manager_NUMBER) — number
  • managerAFF (manager_AFF) — varchar(20)
  • loginTIME (login_TIME) — datetime
  • logoutTIME (logout_TIME) — datetime
  • Field

products info (Untitled2)

  • productNUMBER (porduct_NUMBER) — number — Primary key — NOT NULL
  • productsNAME (products_NAME) — nvarchar2(20)
  • productsAMMOUNTS (products_AMMOUNTS) — number
  • productsCOST (products_COST) — nvarchar2(20)
  • manuDATE (manu_DATE) — date
  • manuLOC (manu_LOC) — nvarchar2(40)
  • wareDATE (ware_DATE) — datetime
  • productscondition (products_condition) — nvarchar(5)
  • productCLASS (product_CLASS) — nvarchar(20)
  • productTYPE (product_TYPE) — nvarchar(30)
  • sugarCONTENT (sugar_CONTENT) — nvarchar(10)
  • Field
  • userID (user_ID) — varchar2(20) — Foreign key → user info.userID — NOT NULL

recommand (Untitled6)

    sales volume (Untitled5)

    • productNUMBER (porduct_NUMBER) — number — Foreign key → manage products.productNUMBER — NOT NULL

    user info (Untitled)

    • userID (user_ID) — varchar2(20) — Primary key — NOT NULL
    • userPASSWORD (user_PASSWORD) — varchar2(20)
    • userNAME (user_NAME) — nvarchar2(20)
    • userNUMBER (user_NUMBER) — number
    • userLOC (user_LOC) — nvarchar2(30)
    • userEmail (user_Email) — nvarchar(40)
    • userGender (user_Gender) — nvarchar(2)
    • userBIRTH (user_BIRTH) — number
    • Field