project

Tables (18)

admin

  • Key — Foreign key → member.id — NOT NULL

adminMenu

  • Key — Foreign key → admin.Key — NOT NULL

answer

  • Key — Foreign key → article.Key — NOT NULL
  • content (Field)
  • author (Field2)
  • createDate (Field3)
  • modifyDate (Field4)
  • like (Field5)
  • reply (Field6)

article

  • Key — Foreign key → member.id — NOT NULL
  • subject (Field)
  • content (Field2)
  • createDate (Field3)
  • modifyDate (Field4)
  • hit (Field5)
  • like (Field6)
  • category_id (Field7)
  • img (Field8)
  • author (Field9)

articleImg

  • (Key) — Foreign key → article.Key — NOT NULL
  • article_id (Field)

category

  • Key — Foreign key → article.Key — NOT NULL
  • front (Field)
  • back (Field2)
  • AI (Field3)
  • dataengineer (Field4)
  • Field5
  • Field6
  • Field7

follower

  • Key — Foreign key → member.id — NOT NULL

member

  • id (Key) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • email (Field3)
  • skill (Field4)
  • profileImg (Field5)
  • sex (Field6)
  • age (Field7)
  • position (Field8)
  • authrization (Field9)
  • money (Field10)

menu (Untitled11)

    message

    • Key — Foreign key → member.id — NOT NULL
    • content (Field)
    • createDate (Field2)
    • check (Field3)
    • author (Field4)
    • 받는사람 (Field5)

    position

    • id (Key) — Foreign key → member.id — NOT NULL
    • front (Field)
    • back (Field2)
    • dataengineer (Field3)
    • Field4
    • Field5
    • Field6

    profile (Untitled9)

      project

      • Key — Foreign key → team.Key — NOT NULL
      • Key (Key2) — Foreign key → teamMember.member_id — NOT NULL
      • Key (Key3) — Foreign key → member.id — NOT NULL
      • projectname (Field)
      • state (Field2)

      reply

      • Key — Foreign key → answer.Key — NOT NULL
      • content (Field)
      • author (Field2)
      • createDate (Field3)
      • modifyDate (Field4)

      skill

      • id (Key) — Foreign key → member.id — NOT NULL
      • C (Field)
      • java (Field2)
      • c++ (Field3)
      • Field4

      state

      • Key — Foreign key → project.Key — NOT NULL
      • Key (Key2) — Foreign key → project.Key — NOT NULL
      • project_id (Key3) — Foreign key → project.Key — NOT NULL
      • content (Field)
      • state (Field2)

      team

      • Key — Foreign key → member.id — NOT NULL
      • teamname (Field)
      • introduce (Field2)

      teamMember

      • member_id (Key) — Foreign key → team.Key — NOT NULL
      • team_id (Field)