당고짱
테이블 (8)
board
- board_id — INT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- title — varchar(255) — NOT NULL
- word_count — INT
- views — INT
- board_content — VARCHAR(500)
- original_file_name — varchar(500)
- saved_file_name — varchar(500)
- create_date — DATETIME
- modify_date — DATETIME
board_likes
- board_like_id — BIGINT — 기본 키 — NOT NULL
- board_id — INT — 외래 키 → board.board_id — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
card
- card_id — BIGINT — 기본 키 — NOT NULL
- deck_id — BIGINT — 외래 키 → deck.deck_id — NOT NULL
- word — VARCHAR(100) — NOT NULL
- pos — VARCHAR(50)
- meaning — VARCHAR(255)
- example_jp — VARCHAR(500)
- example_kr — VARCHAR(500)
- study_level — INT
- studied_at — DATETIME
category
- category_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- category_name — VARCHAR(50) — NOT NULL
deck
- deck_id — BIGINT — 기본 키 — NOT NULL
- category_id — BIGINT — 외래 키 — NOT NULL
- deck_name — VARCHAR(50) — NOT NULL
deck_study_time
- study_time_id — BIGINT — 기본 키 — NOT NULL
- deck_id — BIGINT — 외래 키 → deck.deck_id — NOT NULL
- study_time — INT
- date — DATETIME
reply
- reply_id — INT — 기본 키 — NOT NULL
- board_id — INT — 외래 키 → board.board_id — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- content — VARCHAR(100) — NOT NULL
- created_at — DATETIME
- parent_reply_id — INT
users
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(50)
- user_name — VARCHAR(50) — NOT NULL
- auth_type — VARCHAR(50) — NOT NULL
- password — VARCHAR(255)
- provider_id — VARCHAR(255)
- roles — varchar(50)
- created_at — DATETIME
- profile_image — INT — NOT NULL