FUPTO
Tables (5)
Alert (알림)
- alert_id (알림_아이디) — varchar(100) — Primary key — NOT NULL
- target_price (목표 가격) — varchar(50) — NOT NULL
- created_at (생성날짜) — timestamp
- updated_at (수정날짜) — timestamp
- user_id (사용자_아이디) — varchar(100) — Foreign key → User.user_id — NOT NULL
- product_id (상품 _아이디) — varchar(100) — Foreign key → Product.product_id — NOT NULL
Price (가격)
- price_id (가격_아이디) — varchar(100) — Primary key — NOT NULL
- price (가격) — varchar(50) — NOT NULL
- created_at (생성날짜) — timestamp
- updated_at (수정날짜) — timestamp
- product_id (상품 _아이디) — varchar(100) — Foreign key → Product.product_id — NOT NULL
- store_id (상점_아이디) — varchar(100) — Foreign key → Store.store_id — NOT NULL
Product (상품)
- product_id (상품 _아이디) — varchar(100) — Primary key — NOT NULL
- username (상품_이름) — varchar(50) — NOT NULL
- category (카테고리) — varchar(50)
- brand (브랜드) — varchar(100)
- description (설명) — varchar(500)
- created_at (생성날짜) — timestamp
- updated_at (수정날짜) — timestamp
Store (상점)
- store_id (상점_아이디) — varchar(100) — Primary key — NOT NULL
- s_name (상점_이름) — varchar(50) — NOT NULL
- s_url (상점 url) — varchar(255) — NOT NULL
- created_at (생성날짜) — timestamp
- updated_at (수정날짜) — timestamp
User (사용자)
- user_id (사용자_아이디) — varchar(100) — Primary key — NOT NULL
- username (사용자_이름) — varchar(50) — NOT NULL
- password (패스워드) — varchar(100) — NOT NULL
- email (이메일) — varchar(100)
- created_at (생성날짜) — timestamp
- updated_at (수정날짜) — timestamp