scd

Tables (3)

Schedule (일정)

  • PK (schedule_id) — bigint — Primary key — NOT NULL
  • FK (user_id) — bigint — Foreign key → User.PK — NOT NULL
  • 비밀번호 (password) — varchar(10) — NOT NULL
  • 제목 (title) — varchar(10) — NOT NULL
  • 내용 (contents) — varchar(100) — NOT NULL
  • 작성일 (created_at) — timestamp — NOT NULL
  • 수정일 (updated_at) — timestamp

User (유저)

  • PK (user_id) — bigint — Primary key — NOT NULL
  • 이름 (user_name) — varchar(4) — NOT NULL
  • 이메일 (user_email) — varchar(20) — NOT NULL
  • 비밀번호 (password) — varchar(10) — NOT NULL
  • 작성일 (created_at) — timestamp — NOT NULL
  • 수정일 (updated_at) — timestamp — NOT NULL

reply (댓글)

  • PK (reply_id) — bigint — Primary key — NOT NULL
  • FK (schedule_id) — bigint — Foreign key → Schedule.PK — NOT NULL
  • FK (user_id) — bigint — Foreign key → User.PK — NOT NULL
  • 내용 (contents) — varchar(100) — NOT NULL
  • 작성일 (created_at) — timestamp — NOT NULL
  • 수정일 (updated_at) — timestamp — NOT NULL