BallonTeer
Tables (6)
Activity (Untitled)
- activity_id (Key) — int — Primary key — NOT NULL
- title (Field) — varchar
- description (Field4) — varchar
- start_date (Field2) — datetime
- end_date (Field3) — datetime
- target (Field5) — varchar
- region (Field6) — varchar
- type (Field7) — varchar
- capacity (Field8) — int
Comment (Untitled6)
- comment_id (Key) — int — Primary key — NOT NULL
- content (Field) — varchar
- user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
- post_id (Key3) — int — Foreign key → Post.post_id — NOT NULL
Post (Untitled5)
- post_id (Key) — int — Primary key — NOT NULL
- title (Field) — varchar
- content (Field2) — varchar
- type (Field3) — enum
- user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
Recruit (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- activity_id (Key2) — int — Foreign key → Activity.activity_id — NOT NULL
- user_id (Key3) — int — Foreign key → User.user_id — NOT NULL
Review (Untitled4)
- review_id (Key) — int — Primary key — NOT NULL
- title (Field) — varchar
- content (Field2) — varchar
- activity_id (Key2) — int — Foreign key → Activity.activity_id — NOT NULL
- user_id (Key3) — int — Foreign key → User.user_id — NOT NULL
User (Untitled3)
- user_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- phone_number (Field2) — varchar
- email (Field3) — varchar
- gender (Field4) — enum