Spring_Project_ToDo

Tables (4)

comment (Untitled3)

  • comment_uuid (Key) — bigint — Primary key — NOT NULL
  • contents (Field2) — varchar(2000)
  • todo_uuid (Key3) — bigint — Foreign key → todo.todo_uuid — NOT NULL
  • user_name (Field22) — varchar(10) — Foreign key → user.user_name

login (Untitled4)

  • user_name (Field22) — varchar(10) — Foreign key → user.user_name
  • login_ip (Field) — varchar(50)
  • login_date (Field2) — date

todo (Untitled2)

  • todo_uuid (Key) — bigint — Primary key — NOT NULL
  • todo_title (Field) — varchar(100)
  • todo_contents (Field2) — varchar(5000)
  • todo_date (Field3) — date
  • todo_isDone (Field4) — boolean
  • user_name (Field22) — varchar(10) — Foreign key → user.user_name

user (Untitled)

  • user_name (Field2) — varchar(10) — Primary key
  • user_password (Field) — varchar(15)
  • user_status (Field3) — boolean
  • user_uuid (Field4) — bigint