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