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