upsight

Tables (5)

BaseTable (Untitled)

  • Field (생성일자)
  • Field2 (수정일자)
  • Field3 (삭제여부)

FileInfo (파일정보)

  • id (파일ID) — char(13) — Primary key — NOT NULL
  • originalFileName (원본파일명) — varchar(255) — NOT NULL
  • ext (확장자) — varchar(4) — NOT NULL
  • size (파일크기) — bigint — NOT NULL
  • dirPath (폴더경로) — varchar(255) — NOT NULL
  • storedFileName (저장된파일명) — varchar(255) — NOT NULL

Product (상품)

  • id (상품ID) — char(13) — Primary key — NOT NULL
  • name (상품명) — varchar(20) — NOT NULL
  • amount (재고량) — unsigned int — NOT NULL
  • description (상품설명) — text — NOT NULL

ProductFile (상품파일)

  • id (상품파일ID) — char(13) — Primary key — NOT NULL
  • fileId (파일ID) — char(13) — Foreign key → FileInfo.id — NOT NULL
  • isThumnail (대표이미지여부) — tinyint(1) — NOT NULL
  • productId (상품ID) — char(13) — Foreign key → Product.id — NOT NULL

User (Untitled2)