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)