당고찬 2

테이블 (8)

board

  • board_id — INT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — 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 — 외래 키 → board.user_id — NOT NULL

card

  • card_id — BIGINT — 기본 키 — NOT NULL
  • deck_id — BIGINT — 외래 키 → deck.deck_id — NOT NULL
  • category_id — BIGINT — 외래 키 → deck.category_id — NOT NULL
  • user_id — BIGINT — 외래 키 → deck.user_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

category

  • category_id — BIGINT
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL

deck

  • deck_id — BIGINT — 기본 키 — NOT NULL
  • category_id — BIGINT — 외래 키 → category.category_id — NOT NULL
  • user_id — BIGINT — 외래 키 → category.user_id — 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
  • user_id — BIGINT — 외래 키 → deck.user_id — NOT NULL
  • study_time — TIME
  • date — DATETIME

reply

  • reply_id — INT — 기본 키 — NOT NULL
  • board_id — INT — 외래 키 → board.board_id — NOT NULL
  • user_id — BIGINT — 외래 키 → board.user_id — NOT NULL
  • content — VARCHAR(100) — NOT NULL
  • created_at — DATETIME
  • parent_reply_id — INT

users

  • user_id — BIGINT
  • 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