CH3. SheduleDevelop

Tables (3)

comments (Untitled3)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • contents (내용) — VARCHAR(200)
  • created_at (작성일) — DateTime(6)
  • modified_at (수정일) — DateTime(6)
  • user_id (FK1) — BIGINT — Foreign key → users.id — NOT NULL
  • schedule_id (FK2) — BIGINT — Foreign key → schedules.id — NOT NULL

schedules (Untitled2)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • title (제목) — VARCHAR(50)
  • contents (내용) — VARCHAR(200)
  • created_at (작성일) — DateTime(6)
  • modified_at (수정일) — DateTime(6)
  • user_id (FK) — BIGINT — Foreign key → users.id — NOT NULL

users (Untitled)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • userName (유저명) — VARCHAR(10)
  • email (이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(100)
  • created_at (작성일) — DateTime(6)
  • modified_at (수정일) — DateTime(6)