Final PJT
Tables (22)
article_bookmarks
- id — INT
- user_id — INT — NOT NULL
- article_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_article_bookmarks_user
- INDEX — idx_article_bookmarks_article
article_likes
- id — INT
- user_id — INT — NOT NULL
- article_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_article_likes_user
- INDEX — idx_article_likes_article
articles
- id — INT
- author_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- INDEX — idx_articles_author
attendance_logs
- id — INT
- user_id — INT — NOT NULL
- date — DATE — NOT NULL
- INDEX — idx_attendance_user
comment_likes
- id — INT
- user_id — INT — NOT NULL
- comment_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_comment_likes_user
- INDEX — idx_comment_likes_comment — comment_id
comments
- id — INT
- article_id — INT — NOT NULL
- author_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_comments_article
- INDEX — idx_comments_author
deposit_product_likes
- id — INT
- user_id — INT — NOT NULL
- product_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_deposit_likes_user
- INDEX — idx_deposit_likes_product
deposit_product_options
- id — INT
- product_id — INT — NOT NULL
- intr_rate_type_nm — VARCHAR(50)
- intr_rate — FLOAT
- intr_rate2 — FLOAT
- save_trm — FLOAT
- INDEX — idx_deposit_options_product
deposit_products
- id — INT
- fin_prdt_cd — VARCHAR(100) — NOT NULL
- kor_co_nm — VARCHAR(255) — NOT NULL
- fin_prdt_nm — VARCHAR(255) — NOT NULL
follows
- id — INT
- follower_id — INT — NOT NULL
- following_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_follows_follower
- INDEX — idx_follows_following
gameplay_logs
- id — INT
- user_id — INT — NOT NULL
- date — DATE — NOT NULL
- INDEX — idx_gameplay_user
gold_price
- id — INT
- bas_dt — VARCHAR(20)
- itms_nm — VARCHAR(100)
- clpr — BIGINT
interaction_events
- id — INT
- user_id — INT — NOT NULL
- action — VARCHAR(100)
- target_type — VARCHAR(100)
- target_id — VARCHAR(100)
- metadata — JSON
- created_at — DATETIME — NOT NULL
- INDEX — idx_interaction_user
oil_price
- id — INT
- bas_dt — VARCHAR(20)
- oil_ctg — VARCHAR(50)
- wt_avg_prc_cptn — DECIMAL(18,4)
savings_product_likes
- id — INT
- user_id — INT — NOT NULL
- product_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_savings_likes_user
- INDEX — idx_savings_likes_product
savings_product_options
- id — INT
- product_id — INT — NOT NULL
- intr_rate_type_nm — VARCHAR(50)
- intr_rate — FLOAT
- intr_rate2 — FLOAT
- save_trm — FLOAT
- rsrv_type_nm — VARCHAR(50)
- INDEX — idx_savings_options_product
savings_products
- id — INT
- fin_prdt_cd — VARCHAR(100) — NOT NULL
- kor_co_nm — VARCHAR(255) — NOT NULL
- fin_prdt_nm — VARCHAR(255) — NOT NULL
user_profiles
- id — INT
- user_id — INT — NOT NULL
- phone_number — VARCHAR(50)
- job — VARCHAR(100)
- annual_salary — INT
- asset — INT
- profile_picture — VARCHAR(255)
- points — INT
- INDEX — idx_user_profiles_user_id
users
- id — INT
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(255) — NOT NULL
- is_staff — BOOLEAN
- is_active — BOOLEAN
- date_joined — DATETIME — NOT NULL
youtube_likes
- id — INT
- user_id — INT — NOT NULL
- video_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_youtube_likes_user
- INDEX — idx_youtube_likes_video
youtube_videos
- id — INT
- video_id — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- channel_title — VARCHAR(255)
- thumbnail_url — VARCHAR(255)
- published_at — DATETIME
youtube_watch_later
- id — INT
- user_id — INT — NOT NULL
- video_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_watch_later_user
- INDEX — idx_watch_later_video