Look
Tables (7)
Comment (Untitled3)
- cno (Key) — bigint — Primary key — NOT NULL — auto_increment
- writer (Field) — varchar(200)
- content (Field2) — text
- reg_at (Field3) — datetime
- mod_at (Field4) — datetime
- Lbno (Key2) — bigint — Foreign key → LBoard.Lbno — NOT NULL
File (Untitled2)
- uuid (Key) — Primary key — NOT NULL
- save_dir (Field) — varchar(256)
- file_name (Field2) — varchar(256)
- file_type (Field3) — tinyint(1)
- file_size (Field4) — bigint
- reg_at (Field5) — datetime
- Lbno (Key2) — bigint — Foreign key → LBoard.Lbno — NOT NULL
LBoard (Untitled)
- Lbno (Key) — bigint — Primary key — NOT NULL
- title (Field) — varchar(200)
- writer (Field2) — varchar(200)
- content (Field3) — text
- reg_at (Field4) — datetime
- mod_at (Field5) — datetime
- read_count (Field6) — int
- like (Field7)
NBoard (Untitled4)
- Nbno (Key) — bigint — Primary key — NOT NULL — auto_increment
- title (Field) — varchar(200)
- writer (Field2) — varchar(200)
- content (Field3) — text
- reg_at (Field4) — datetime
- read_count (Field5) — int
QBoard (Untitled5)
- Qbno (Key) — bigint — Primary key — NOT NULL
- title (Field) — varchar
- writer (Field2) — varchar(100)
- content (Field3) — text
- reg_at (Field4) — datetime
User (Untitled6)
- email (Key) — varchar(100) — Primary key — NOT NULL
- pw (Field) — varchar(100)
- nick_name (Field2)
- reg_at (Field3) — datetime
- last_login (Field4) — datetime
- Field5
auth_user (Untitled7)
- auth (Field) — varchar(50)
- email (Key) — varchar(100) — Foreign key → User.email — NOT NULL