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`