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