Easy
Tables (4)
Admin (Untitled2)
- admin_no (Key) — int — Primary key — NOT NULL
- admin_id (Field) — varchar(20)
- admin_pw (Field2) — varchar(100)
Board (Untitled3)
- Board_no (Key) — int — Primary key — NOT NULL
- User_no (Key2) — int — Foreign key → User.User_no — NOT NULL
- category_name (Field) — varchar(255)
- board_name (Field2) — varchar(255)
- board_text (Field3) — varchar(255)
- board_date (Field4) — timestamp
Comment (Untitled4)
- comment_no (Key) — int — Primary key — NOT NULL
- User_no (Key2) — int — Foreign key → User.User_no — NOT NULL
- Field
User (Untitled)
- User_no (Key) — int — Primary key — NOT NULL
- User_id (Field2) — varchar(20)
- User_password (Field3) — varchar(100)
- Use_nickname (Field4) — varchar(20)
- User_birth (Field) — varchar(20)
- User_tel (Field5) — varchar(13)