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