jpa-todo

Tables (3)

Comment (댓글)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • contents (Field) — VARCHAR(100) — NOT NULL
  • created_at (Field2) — DATETIME(6)
  • modified_at (Field3) — DATETIME(6)
  • user_id (Foreign Key) — BIGINT — Foreign key → User.id — NOT NULL
  • schedule_id (Foreign Key2) — BIGINT — Foreign key → Schedule.id — NOT NULL

Schedule (일정)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(50) — NOT NULL
  • contents (Field2) — LONGTEXT — NOT NULL
  • created_at (Field3) — DATETIME(6)
  • modified_at (Field4) — DATETIME(6)
  • user_id (Foreign Key) — BIGINT — Foreign key → User.id — NOT NULL

User (유저)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • username (Field) — VARCHAR(50) — NOT NULL
  • email (Field2) — VARCHAR(50) — NOT NULL
  • password (Field3) — VARCHAR(100) — NOT NULL
  • created_at (Field4) — DATETIME(6)
  • modified_at (Field5) — DATETIME(6)