Pramisu

Tables (4)

Alarm (alarm)

  • Alarm Id (alarm_id) — VARCHAR(255) — Primary key — NOT NULL
  • From User Id (from_user_id) — VARCHAR(255) — Foreign key → User.User Id — NOT NULL
  • To User Id (to_user_id) — VARCHAR(255)
  • Alarm Type (alarm_type) — VARCHAR(50)
  • Alarm Date (alarm_date) — CHAR(8)
  • Title (title) — VARCHAR(50)
  • Content (content) — VARCHAR(255) — NOT NULL
  • Is Read (is_read) — CHAR(1)

Friend (friend)

  • User Id (user_id) — VARCHAR(255) — Foreign key → User.User Id — NOT NULL
  • Request Date (request_date) — CHAR(8)
  • Is Friend (is_friend) — CHAR(1)

Quest (quest)

  • Quest Id (quest_id) — VARCHAR(255) — Primary key — NOT NULL
  • From User Id (from_user_id) — VARCHAR(255) — Foreign key → User.User Id — NOT NULL
  • To User Id (to_user_id) — VARCHAR(255)
  • Title (title) — VARCHAR(50)
  • Content (content) — VARCHAR(255) — NOT NULL
  • Start Date (start_date) — CHAR(8)
  • End Date (end_date) — CHAR(8)
  • Is Completed (is_completed) — CHAR(1)
  • Is Closed (is_closed) — CHAR(1)

User (user)

  • User Id (user_id) — VARCHAR(255) — Primary key — NOT NULL
  • Token (token) — VARCHAR(255)
  • NickName (nickname) — VARCHAR(50)
  • Profile Image (profile_image) — VARCHAR(255)