Eskimo
Tables (12)
member_account (CopyOfUntitled3)
- memberId (Key) — LONG — Primary key — NOT NULL
- userid (Field7) — VARCHAR
- userpw (Field8) — VARCHAR
- email (Field9) — VARCHAR
- username (Field) — VARCHAR
member_info (Untitled3)
- memberId (Key) — LONG — Primary key — NOT NULL
- role (Field2) — ENUM
- stack (Field3) — ENUM
- contact (Field4) — VARCHAR
- area (Field5) — VARCHAR
- level (Field6) — LONG
- description (Field10) — VARCHAR
profile_image (Untitled4)
- imageId (Key) — LONG — Primary key — NOT NULL
- memberId (Key2) — LONG — Foreign key → member_info.memberId — NOT NULL
- fileLocation (Field2) — VARCHAR
project (Untitled)
- projectId (Key) — LONG — Primary key — NOT NULL
- projectStatusId (Key2) — LONG — Foreign key → project_status.projectStatusId — NOT NULL
- projectName (Field) — VARCHAR
- teamName (Field2) — VARCHAR
- endDate (Field5) — DATETIME
- description (Field12) — VARCHAR
- currentDeveloper (Field3) — LONG
- currentDesigner (Field6) — LONG
- currentPlanner (Field7) — LONG
- currentETC (Field8) — LONG
- needDeveloper (Field9) — LONG
- needDesigner (Field10) — LONG
- needPlanner (Field11) — LONG
- needETC (Field13) — LONG
- status (Field4) — ENUM
- location (Field15) — VARCHAR
- occupation (Field16) — VARCHAR
- dday (Field17) — LONG
- field (Field18) — VARCHAR
project_answer (Untitled6)
- projectanswerId (Key) — LONG — Primary key — NOT NULL
- projectquestionId (Key2) — LONG — Foreign key → project_question.projectquestionId — NOT NULL
- projectmemberId (Key3) — LONG — Foreign key → project_member.projectmemberId — NOT NULL
- answer (Field) — VARCHAR
project_ended (CopyOfUntitled)
- projectendedId (Key) — LONG — Primary key — NOT NULL
- projectName (Field) — VARCHAR
- teamName (Field2) — VARCHAR
- endDate (Field5) — DATETIME
- description (Field12) — VARCHAR
project_ended_member (CopyOfUntitled2)
- projectendedmemberId (Key) — LONG — Primary key — NOT NULL
- memberId (Key2) — LONG — Foreign key → member_account.memberId — NOT NULL
- projectId (Field) — LONG
- role (Field2) — ENUM
- stack (Field3) — ENUM
- selDescription (Field4) — BLOB
project_image (CopyOfUntitled4)
- imageId (Key) — LONG — Primary key — NOT NULL
- Key4 — Primary key — NOT NULL
- projectId (Key3) — LONG — Foreign key → project.projectId — NOT NULL
- projectStatusId (Key2) — LONG — Foreign key → project.projectStatusId — NOT NULL
- fileLocation (Field2) — VARCHAR
project_member (Untitled2)
- projectmemberId (Key) — LONG — Primary key — NOT NULL
- projectId (Key3) — LONG — Foreign key → project.projectId — NOT NULL
- role (Field2) — ENUM
- stack (Field3) — ENUM
- selDescription (Field4) — BLOB
project_question (Untitled5)
- projectquestionId (Key) — LONG — Primary key — NOT NULL
- projectId (Key3) — LONG — Foreign key → project.projectId — NOT NULL
- question (Field) — VARCHAR
project_recruit (Untitled8)
- projectRecruitId (Key) — LONG — Primary key — NOT NULL
- memberId (Key2) — LONG — Foreign key → member_account.memberId — NOT NULL
- projectId (Key3) — LONG — Foreign key → project.projectId — NOT NULL
- role (Field) — VARCHAR
- self_description (Field2) — VARCHAR
- status (Field3) — VARCHAR
project_status (Untitled7)
- projectStatusId (Key) — LONG — Primary key — NOT NULL
- userId (Field2) — VARCHAR
- status (Field4) — VARCHAR
- plan (Field5) — BOOLEAN