togethering
Tables (7)
PloggingCrouse (PloggingCourse)
- id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHARO(50)
- metadata (Field2) — LONGTEXT
- created_at (Field3) — DATETIME(6)
- updated_at (Field4) — DATETIME(6)
PloggingGroup
- id (Key) — BIGINT(auto increment) — Primary key — NOT NULL
- course_id (Field) — BIGINT
- address (Field2) — VARCHAR(255)
- status (Field3) — ENUM('before', 'during', 'after')
- during_date (Field4) — DATETIME(6)
- updated_at (Field5) — DATETIME(6)
- created_at (Field6) — DATETIME(6)
PloggingGroupPicture
- id (Key) — BIGINT — Primary key — NOT NULL
- plogging_group_id (Field) — BIGINT
- imgae_url (Field2) — VARCHAR(255)
- created_at (Field3) — DATETIME(6)
- updated_at (Field4) — DATETIME(6)
PloggingGroupReview
- id (PK) — BIGINT — Primary key — NOT NULL
- plogging_group_id (FK1) — BIGINT
- user_id (FK2) — BIGINT
- reward (Field3) — INT
- content (Field4) — LONGTEXT
- created_at (Field5) — DATETIME(6)
- updated_at (Field6) — DATETIME(6)
PloggingGroupReviewPicture
- id (Key) — BIGINT — Primary key — NOT NULL
- plogging_group_review_id (FK) — BIGINT
- image_url (Field2) — VARCHAR(255)
- created_at (Field3) — DATETIME(6)
- updated_at (Field4) — DATETIME(6)
User
- id (Key) — BIGINT(auto increment) — Primary key — NOT NULL
- nickname (Field) — VARCHAR(50)
- email (Field2) — VARCHAR(50)
- password (Field3) — VARCHAR(70)
- profile_image_url (Field4) — VARCHAR(255)
- user_address (Field5) — VARCHAR(255)
- created_at (Field6) — DATETIME(6)
- updated_at (Field7) — DATETIME(6)
UserPloggingGroupApplyment
- user_id (Key) — BIGINT — Primary key — NOT NULL
- plogging_group_id (Key2) — BIGINT — Primary key — NOT NULL
- is_plogging_admin (Field) — BIT
- created_at (Field3) — DATETIME(6)
- updated_at (Field4) — DATETIME(6)