1
Tables (14)
Buyer
- BuyerId — VARCHAR2(30) — Primary key — NOT NULL
- AUTH_ID — NUMBER — Foreign key → ROLE.AUTH_ID — NOT NULL
- BuyerName — VARCHAR2(30)
- BuyerPassword — VARCHAR2(30)
- BuyerEmail — VARCHAR2(30)
- BuyerBirth — DATE
- BuyerAddress — VARCHAR2(255)
- BuyerZipCode — NUMBER
- BuyerPhoneNumber — NUMBER
- BuyerSignUpDate — DATE
- Field — DATE
- DELETE_YN — CHAR(1)
Product
- ProductId — NUMBER — Primary key — NOT NULL
- Key — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key2 — NUMBER — Foreign key → Untitled7.Key — NOT NULL
- SellerId — VARCHAR2(30) — Foreign key → Seller.SellerId — NOT NULL
- ProductName — VARCHAR2(255)
- ProductExplanation — BLOB
- ProductPrice — NUMBER
- ProductCount — NUMBER
- ProductDiscountPercentage — NUMBER
- ProductClickCount — NUMBER
- ProductRegistrationDate — DATE
ROLE
- AUTH_ID — NUMBER — Primary key — NOT NULL
- AUTH_TYPE — VARCHAR2(255)
- AUTH_ROLE — VARCHAR2(255)
Seller
- SellerId — VARCHAR2(30) — Primary key — NOT NULL
- AUTH_ID — NUMBER — Foreign key → ROLE.AUTH_ID — NOT NULL
- SellerName — VARCHAR2(30)
- SellerPassword — VARCHAR2(30)
- SellerEmail — VARCHAR2(30)
- SellerRegistrationNumber — NUMBER
- SellerAddress — VARCHAR2(255)
- SellerBusinessName — VARCHAR2(30)
- SellerPhoneNumber — NUMBER
- SellerBusinessNumber — NUMBER
- SellerSignUpDate — DATE
- Field — DATE
- DELETE_YN — CHAR(1)
Untitled
- Key — NUMBER — Primary key — NOT NULL
- Field — VARCHAR2(255)
Untitled10
- BuyerId — VARCHAR2(30) — Foreign key → Buyer.BuyerId — NOT NULL
- ProductId — NUMBER — Foreign key → Product.ProductId — NOT NULL
Untitled2
- Key — NUMBER — Primary key — NOT NULL
- BuyerId — VARCHAR2(30) — Foreign key → Buyer.BuyerId — NOT NULL
- ProductId — NUMBER — Foreign key → Product.ProductId — NOT NULL
- Key3 — NUMBER — Foreign key → Untitled5.Key — NOT NULL
- Field — VARCHAR2(255)
- Field2 — VARCHAR2(255)
- Field3 — NUMBER
- Field4 — VARCHAR2(255)
- Field5 — NUMBER
- Field6 — VARCHAR2(255)
- Field7 — DATE
- Field8 — VARCHAR2(255)
- Field9 — NUMBER
Untitled3
- Key — NUMBER — Primary key — NOT NULL
- Key2 — NUMBER — Foreign key → Untitled2.Key — NOT NULL
Untitled4
- Key — NUMBER — Primary key — NOT NULL
- ProductId — NUMBER — Foreign key → Product.ProductId — NOT NULL
- BuyerId — VARCHAR2(30) — Foreign key → Buyer.BuyerId — NOT NULL
- SellerId — VARCHAR2(30) — Foreign key → Seller.SellerId — NOT NULL
- Field — VARCHAR2(255)
- Field2 — VARCHAR2(1000)
- Field3 — DATE
- Field4 — VARCHAR2(1000)
- Field5 — NUMBER
Untitled5
- Key — NUMBER — Primary key — NOT NULL
- Field — VARCHAR2(255)
- Field2 — NUMBER
- Field3 — NUMBER
- Field4 — DATE
- Field5 — VARCHAR2(255)
- Field6 — CHAR(1)
- Field7 — NUMBER
Untitled6
- Key — NUMBER — Foreign key → Untitled5.Key — NOT NULL
- ProductId — NUMBER — Foreign key → Product.ProductId — NOT NULL
- BuyerId — VARCHAR2(30) — Foreign key → Buyer.BuyerId — NOT NULL
- Field2 — DATE
- Field3 — CHAR(1)
Untitled7
- Key — NUMBER — Primary key — NOT NULL
- Field — NUMBER
- Field2 — BLOB
- Field3 — VARCHAR2(255)
Untitled8
- Key — NUMBER — Primary key — NOT NULL
- Key2 — NUMBER — Foreign key → Untitled2.Key — NOT NULL
- Field — VARCHAR2(255)
Untitled9
- Key — NUMBER — Primary key — NOT NULL
- BuyerId — VARCHAR2(30) — Foreign key → Buyer.BuyerId — NOT NULL
- ProductId — NUMBER — Foreign key → Product.ProductId — NOT NULL
- Field — NUMBER