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