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