2023 capstone
Tables (7)
Auction (매물)
- ID (Key) — INT — Primary key — NOT NULL
- Author_ID (FK2) — INT — Foreign key → User.ID — NOT NULL
- Category_ID (PK) — INT — Foreign key → Category.ID — NOT NULL
- ID (PK2) — INT — Foreign key → User.ProfilePic_url — NOT NULL
- Create_Date (Field2) — TIMESTAMP
- Title (Field) — TEXT
- Price (Field4) — INT
- Description (Field5) — TEXT
- Location (Field3) — TEXT
- Type (Field6) — ENUM
- Status (Field7) — ENUM
Auction_Image_Link (매물이미지연결)
- ID (PF) — INT — Primary key — NOT NULL
- Image_ID (FK) — INT — Foreign key → Image_URL.ID — NOT NULL
- Auction_ID (FK2) — INT — Foreign key → Auction.ID — NOT NULL
Bid (입찰)
- ID (PK) — INT — Primary key — NOT NULL
- Auticon_ID (FK) — INT — Foreign key → Auction.ID — NOT NULL
- Author_ID (FK2) — INT — Foreign key → User.ID — NOT NULL
- Price (Field) — INT
- Create_Date (Field2) — TIMESTAMP
Category (카테고리)
- ID (PK) — INT — Primary key — NOT NULL
- Parent_ID (FK) — INT — Foreign key → Category.ID — NOT NULL
- Name (Field) — TEXT
Comment (댓글)
- ID (PK) — INT — Primary key — NOT NULL
- Auction_ID (FK) — INT — Foreign key → Auction.ID — NOT NULL
- Author_ID (FK3) — INT — Foreign key → User.ID — NOT NULL
- Parent_ID (FK2) — INT — Foreign key → Comment.ID — NOT NULL
- Content (Field) — TEXT
- Create_Date (Field2) — TIMESTAMP
Image_URL (이미지URL)
- ID (PK) — INT — Primary key — NOT NULL
- URL (Field) — TEXT
- Descripton (Field2) — TEXT
User (유저)
- ID (PK) — INT — Primary key — NOT NULL
- ProfilePic_url (FK) — INT — Foreign key → Image_URL.ID — NOT NULL
- Name (Field) — TEXT
- Bio (Field2) — TEXT
- Regist_Date (Field4) — TIMESTAMP