pjt 12/19

Tables (7)

article

  • article_id — BIGINT — Primary key — NOT NULL
  • user_email — VARCHAR(255) — Foreign key → user.email — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • INDEX — `idx_article_user_email`

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • author_email — VARCHAR(255) — Foreign key → user.email — NOT NULL
  • article_id — BIGINT — Foreign key → article.article_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — `idx_comment_author_email`
  • INDEX — `idx_comment_article_id`

deposit_product

  • deposit_id — BIGINT — Primary key — NOT NULL
  • deposit_amount — BIGINT — NOT NULL
  • maturity_date — DATE — NOT NULL
  • interest_rate — DECIMAL(5,2) — NOT NULL
  • user_email — VARCHAR(255) — Foreign key → user.email — NOT NULL
  • INDEX — `idx_deposit_user_email`

metal_price

  • metal_price_id — BIGINT — Primary key — NOT NULL
  • metal_type — ENUM('GOLD','SILVER') — NOT NULL
  • price_date — DATE — NOT NULL
  • close_last — DECIMAL(18,6) — NOT NULL
  • volume — BIGINT
  • open — DECIMAL(18,6) — NOT NULL
  • high — DECIMAL(18,6) — NOT NULL
  • low — DECIMAL(18,6) — NOT NULL

recommendation

  • recommendation_id — BIGINT — Primary key — NOT NULL
  • user_email — VARCHAR(255) — Foreign key → user.email — NOT NULL
  • deposit_id — BIGINT — Foreign key → deposit_product.deposit_id — NOT NULL
  • recommended_at — DATETIME — NOT NULL
  • INDEX — `idx_rec_user_email`
  • INDEX — `idx_rec_deposit_id`

user

  • email — VARCHAR(255) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • job — VARCHAR(100)
  • property — BIGINT
  • yearearnmoney — BIGINT

youtube_search

  • youtube_search_id — BIGINT — Primary key — NOT NULL
  • thumbnail_url — TEXT
  • title — VARCHAR(300) — NOT NULL
  • channel_name — VARCHAR(200) — NOT NULL
  • search_query — VARCHAR(300) — NOT NULL
  • searched_at — DATETIME — NOT NULL
  • INDEX — `idx_youtube_search_query`
  • INDEX — `idx_youtube_searched_at`