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
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