Board
Tables (3)
board_data (Untitled)
- id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → user.id — NOT NULL
- username (Field) — varchar(100)
- title (Field2) — varchar(100)
- content (Field3) — longtext
- img_url (Field4) — varchar(255)
- yyyymmdd (Field5) — date
comment (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- board_id (Key2) — int — Foreign key → board_data.id — NOT NULL
- username (Field) — varchar(100)
- content (Field2) — longtext
- yyyymmdd (Field3) — date
user (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- firstname (Field6) — varchar(100)
- lastname (Field7) — varchar(100)
- username (Field) — varchar(100)
- password (Field3) — varchar(100)
- email (Field4) — varchar(100)
- birthday (Field2) — date
- sex (Field5) — varchar(10)
- phoneNumber (Field8) — varchar(30)