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