ssd

Tables (7)

Category

  • categoryId — Primary key — NOT NULL
  • cName

Community

  • communityId — VARCHAR2(45) — Primary key — NOT NULL
  • fundingId — VARCHAR2(45) — Foreign key → Funding.fundingId — NOT NULL
  • userId — VARCHAR2(45) — Foreign key → User.userId — NOT NULL
  • comment — VARCHAR2(300)

Funding

  • fundingId — VARCHAR2(45) — Primary key — NOT NULL
  • productId — VARCHAR2(45) — Foreign key → Product.productId — NOT NULL
  • calendar — DATE
  • productInformation — VARCHAR2(300)

FundingRelation

  • fundingOrderId — VARCHAR2(45) — Primary key — NOT NULL
  • fundingId — VARCHAR2(45) — Foreign key → Funding.fundingId — NOT NULL
  • userId — VARCHAR2(45) — Foreign key → User.userId — NOT NULL
  • date — DATE
  • status — VARCHAR2(45)

Product

  • productId — String — Primary key — NOT NULL
  • categoryId — String — Foreign key → Category.categoryId — NOT NULL
  • userId — String — Foreign key → User.userId — NOT NULL
  • pName
  • description
  • price
  • quantity
  • productImg

QnA

  • qnaId — VARCHAR2(45) — Primary key — NOT NULL
  • fundingId — VARCHAR2(45) — Foreign key → Funding.fundingId — NOT NULL
  • userId — VARCHAR2(45) — Foreign key → User.userId — NOT NULL
  • comment — VARCHAR2(300)

User (Untitled)

  • userId — VARCHAR2(45) — Primary key — NOT NULL
  • userName (usreName) — VARCHAR2(45)
  • password — VARCHAR2(45)
  • email — VARCHAR2(45)
  • phone — VARCHAR2(45)
  • zipcode — VARCHAR2(45)
  • address — VARCHAR2(45)