투두앱 백엔드 서버

테이블 (3)

Comment (Untitled)

  • comment_id (id) — bigint — 기본 키 — NOT NULL
  • user_id (Key) — bigint — 외래 키 → User.user_id — NOT NULL
  • scheduler_id (Key2) — bigint — 외래 키 → Scheduler.scheduler_id — NOT NULL
  • comment (Field) — varchar
  • create_date (Field4) — timestamp

Scheduler (Untitled3)

  • scheduler_id (Key) — bigint — 기본 키 — NOT NULL
  • title (Field) — varchar
  • contents (Field2) — varchar
  • manager (Field3) — varchar
  • password (Field4) — bigint
  • create_date (Field5) — timestamp

User (Untitled2)

  • user_id (Key) — bigint — 기본 키 — NOT NULL
  • nickname (Field2) — varchar
  • username (Field3) — varchar
  • password (Field4) — varchar
  • authority (Field5) — varchar
  • create_date (Field6) — timestamp