ToDo

Tables (3)

comments (댓글)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Field) — bigint — Foreign key → user.id — NOT NULL
  • todos_id (Field2) — bigint — Foreign key → todos.id — NOT NULL
  • comment (Field3) — text
  • created_date (Field4) — datetime
  • modified_date (Field5) — datetime

todos (투두)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Field) — bigint — Foreign key → user.id — NOT NULL
  • title (Field2) — varchar(255)
  • content (Field3) — text
  • writer (Field4) — varchar(255)
  • view (Field5) — bigint
  • created_date (Field6) — datetime
  • modified_date (Field7) — datetime

user (유저)

  • id (Key) — bigint — Primary key — NOT NULL
  • username (Field) — varchar(255)
  • password (Field2) — varchar(255)
  • nickname (Field3) — varchar(255)
  • email (Field4) — varchar(255)
  • created_date (Field5) — datetime
  • modified_date (Field6) — datetime