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)