seerslab_test_board_database

Tables (3)

board (게시판)

  • board_Id (게시판FK) — int — Primary key — NOT NULL
  • user_Id (유저FK) — int — Foreign key → users.user_Id — NOT NULL
  • titel (제목) — varchar(100) — NOT NULL
  • content (내용) — varchar(1000) — NOT NULL

comments

  • comment_Id (Key) — int — Primary key — NOT NULL
  • user_Id (유저FK) — int — Foreign key → users.user_Id — NOT NULL
  • board_Id (게시판FK) — int — Foreign key → board.board_Id — NOT NULL
  • content (내용) — varchar(1000) — NOT NULL

users (고객)

  • user_Id (유저FK) — int — Primary key — NOT NULL
  • email (이메일) — verchar(50) — NOT NULL
  • password (비밀번호) — varchar(100) — NOT NULL
  • name (이름) — varchar(50) — NOT NULL