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