QMR

Tables (8)

BLOCK

  • block_Id — INT — Primary key — NOT NULL
  • user_Id — INT — Foreign key → USER.user_Id — NOT NULL
  • created_At — DATETIME — NOT NULL

BOARD

  • board_Id — INT — Primary key — NOT NULL
  • user_Id — INT — Foreign key → USER.user_Id — NOT NULL
  • contents — TEXT — NOT NULL
  • hashtag — VARCHAR(50)
  • created_At — DATETIME — NOT NULL

COMMENT

  • comment_Id — INT — Primary key — NOT NULL
  • board_Id — INT — Foreign key → BOARD.board_Id — NOT NULL
  • user_Id — INT — Foreign key → USER.user_Id — NOT NULL
  • contents — TEXT — NOT NULL
  • created_At — DATETIME — NOT NULL

FILE

  • file_Id — INT — Primary key — NOT NULL
  • board_Id — INT — Foreign key → BOARD.board_Id — NOT NULL
  • file_Name — VARCHAR(255) — NOT NULL
  • file_Type — VARCHAR(255) — NOT NULL
  • file_Path — VARCHAR(255) — NOT NULL
  • created_At — DATETIME — NOT NULL

FOLLOW

  • follow_Id — INT — Primary key — NOT NULL
  • user_Id — INT — Foreign key → USER.user_Id — NOT NULL
  • created_At — DATETIME — NOT NULL

LIKE

  • like_Id — INT — Primary key — NOT NULL
  • user_Id — INT — Foreign key → USER.user_Id — NOT NULL
  • board_id — INT — Foreign key → BOARD.board_Id — NOT NULL
  • created_At — DATETIME — NOT NULL

SHARE

  • share_Id — INT — Primary key — NOT NULL
  • user_Id — INT — Foreign key → USER.user_Id — NOT NULL
  • board_Id — INT — Foreign key → BOARD.board_Id — NOT NULL
  • created_At — DATETIME — NOT NULL

USER

  • user_Id — INT — Primary key — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • birthday — DATE — NOT NULL
  • created_At — DATETIME — NOT NULL