With U.( Shared Calendar Project)

공유 캘린더 DB설계 초안

테이블 (3)

Calendar Schedule (calendar_schedule)

  • UserID (user_id) — CHAR(10) — 외래 키 → calendar table.UserID — NOT NULL
  • Title (title) — VARCHAR(100)
  • Content (content) — VARCHAR(255)
  • Date (date) — Date(10)
  • Share (share) — boolean(2)

calendar table (calendar_table)

  • UserID (user_id) — CHAR(10) — 외래 키 → user table.UserID — NOT NULL
  • Approval (approval) — boolean(2)

user table (user_table)

  • UserID (user_id) — CHAR(10) — 기본 키 — NOT NULL
  • User Name (user_name) — CHAR(10)
  • User Hint (user_hint) — VARCHAR(100)
  • User Answer (user_aws) — VARCHAR(150)
  • User Password (user_pw) — VARCHAR(10)
  • User Password Check (user_pw_ck) — VARCHAR(10)