spring-expert

Tables (4)

comment (댓글)

  • id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • todo_id (FK2) — bigint — Foreign key → todo.id — NOT NULL
  • contents (Field) — varchar
  • created_at (Field2) — datetime
  • motified_at (Field3) — datetime

manager (담당자)

  • id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • todo_id (FK2) — bigint — Foreign key → todo.user_id — NOT NULL

todo (할 일)

  • id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • title (Field) — varchar
  • contents (Field2) — varchar
  • weather (Field3) — varchar
  • created_at (Field4) — datetime
  • motified_at (Field5) — datetime

user (유저)

  • id (PK) — bigint — Primary key — NOT NULL
  • username (Field) — varchar
  • email (Field2) — varchar
  • password (Field3) — varchar
  • user_role (Field4) — varchar
  • created_at (Field5) — datetime
  • modified_at (Field6) — datetime