test

Tables (7)

File

  • file_pk — int — Primary key — NOT NULL
  • file — blob
  • post_pk — int — NOT NULL

Participant

  • participant_pk — int — Primary key — NOT NULL
  • project_user_key — int — NOT NULL
  • schedule_pk — int — NOT NULL

Post

  • post_pk — int — Primary key — NOT NULL
  • post_title — varchar
  • post_content — varchar
  • created_at — datetime
  • modified_at — datetime
  • project_user_key — int — NOT NULL

Project

  • project_pk — int — Primary key — NOT NULL
  • project_name — varchar

Project_user

  • project_user_key — int — Primary key — NOT NULL
  • role — enum
  • user_pk — int — NOT NULL
  • project_pk — int — NOT NULL

Schedule

  • schedule_pk — int — Primary key — NOT NULL
  • schedule_name — varchar
  • schedule_memo — varchar
  • schedule_start — datetime
  • schedule_end — datetime
  • schedule_type — varchar

User

  • user_pk — int — Primary key — NOT NULL
  • user_id — varchar
  • password — varchar
  • name — varchar
  • email — varchar
  • phone — varchar