asdf

Tables (4)

CalendarDate (calendardate)

  • date — varchar(20) — Primary key — NOT NULL

Memo (memo)

  • id — Long — Primary key — NOT NULL
  • contnet (내용) — CLOB
  • user (user_id) — User — Foreign key → Users.id — NOT NULL

Schedule (schedule)

  • id — Long — Primary key — NOT NULL
  • author (작성자) — varchar(20) — NOT NULL
  • title (제목) — varchar(20) — NOT NULL
  • contents (내용) — CLOB
  • complete (완료) — boolean — NOT NULL
  • user — User — Foreign key → Users.id — NOT NULL
  • date — varchar(20) — Foreign key → CalendarDate.date — NOT NULL

Users (users)

  • id — Long — Primary key — NOT NULL
  • email (이메일) — varchar(30) — NOT NULL
  • password (PW) — varchar(20) — NOT NULL
  • role (권한) — varchar(10) — NOT NULL
  • username (닉네임) — varchar(15) — NOT NULL