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