myGarden

테이블 (7)

JWT Refresh 토큰 (token_entity)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → 멤버.id — NOT NULL
  • token_text — varchar(255) — NOT NULL
  • token_type — enum — NOT NULL
  • expired — bit — NOT NULL
  • revoked — bit — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

TIL 게시판 (learn_board_entity)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • category_id — bigint — 외래 키 → 게시판 카테고리.id — NOT NULL
  • member_id — bigint — 외래 키 → 멤버.id — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — varchar(4000) — NOT NULL
  • views — int — NOT NULL
  • writer — varchar(30)
  • written_at — datetime(6)
  • created_at — datetime(6)
  • updated_at — datetime(6)

게시판 카테고리 (board_category_entity)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • board_type — varchar(30)
  • code — varchar(30)
  • text — varchar(30)
  • created_at — datetime(6)
  • updated_at — datetime(6)

공지사항 게시판 (notice_board_entity)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • category_id — bigint — 외래 키 → 게시판 카테고리.id — NOT NULL
  • member_id — bigint — 외래 키 → 멤버.id — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — varchar(4000) — NOT NULL
  • views — int — NOT NULL
  • writer — varchar(30)
  • written_at — datetime(6)
  • is_important — bit
  • created_at — datetime(6)
  • updated_at — datetime(6)

댓글 (comment_entity)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • board_id — bigint — 외래 키 → TIL 게시판.id — NOT NULL
  • member_id — bigint — 외래 키 → 멤버.id — NOT NULL
  • board_type — varchar(20) — NOT NULL
  • content — varchar(300) — NOT NULL
  • writer — varchar(30)
  • written_at — datetime(6)
  • created_at — datetime(6)
  • updated_at — datetime(6)

멤버 (member_entity)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • email — varchar(50) — NOT NULL
  • password — varchar(100) — NOT NULL
  • role — enum — NOT NULL
  • enabled — bit — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

하루 일과 (daily_routine_entity)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → 멤버.id — NOT NULL
  • routine_type — enum
  • routine_description — varchar(255)
  • start_date_time — datetime(6)
  • end_date_time — datetime(6)
  • created_at — datetime(6)
  • updated_at — datetime(6)