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)
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
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)