study

Tables (5)

Member (Untitled)

  • member_id (PK) — Primary key — NOT NULL
  • email (Field)
  • nickname (Field2)
  • provider (Field3)
  • provider_id (Field4)

MemberDetails (Untitled2)

  • detail_id (PK) — Primary key — NOT NULL
  • member_id (FK) — Foreign key → Member.member_id — NOT NULL
  • skill (Field)
  • Field2
  • Field3

MemberStats (Untitled3)

  • stats_id (PK) — Primary key — NOT NULL
  • member_id (FK) — Foreign key → Member.member_id — NOT NULL
  • completion_rate (Field)
  • dropout_rate (Field2)

Post (Untitled4)

  • post_id (PK) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • min_rate (Field3)
  • status (Field4)
  • owner_id (FK) — Foreign key → Member.member_id — NOT NULL

applications (Untitled5)

  • cpp_id (PK) — Primary key — NOT NULL
  • status (Field)