개폼 | GAEFORM

테이블 (7)

Untitled (tracker)

  • Key (id) — NUMBER — 기본 키 — NOT NULL
  • Field (project_title) — VARCHAR2 — NOT NULL
  • Field (participant) — VARCHAR2 — NOT NULL
  • Field (contents) — VARCHAR2 — NOT NULL
  • Field (stage) — VARCHAR2 — NOT NULL
  • Field (issue) — VARCHAR2 — NOT NULL
  • Field (output) — VARCHAR2 — NOT NULL
  • Field (project_image) — VARCHAR2 — NOT NULL
  • Field (project_field) — VARCHAR2 — NOT NULL
  • Field (exp_duration) — VARCHAR2 — NOT NULL
  • Field (tools) — VARCHAR2 — NOT NULL
  • Field (like) — NUMBER — NOT NULL

Untitled (portfolio)

  • Key (id) — NUMBER — 기본 키 — NOT NULL
  • Field (project_title) — VARCHAR2 — NOT NULL
  • Field (duration) — VARCHAR2 — NOT NULL
  • Field (position) — VARCHAR2 — NOT NULL
  • Field (description) — VARCHAR2 — NOT NULL
  • Field (participation) — NUMBER — NOT NULL
  • Field (languages) — VARCHAR2 — NOT NULL
  • Field (dbms) — VARCHAR2 — NOT NULL
  • Field (tools) — VARCHAR2 — NOT NULL
  • Field (link) — VARCHAR2 — NOT NULL

Untitled (comment)

  • Key (id) — NUMBER — 기본 키 — NOT NULL
  • 유저ID (user_id) — VARCHAR2 — 외래 키 → Untitled.유저ID — NOT NULL
  • Key (tracker_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Field (create_date) — DATE — NOT NULL
  • Field (comment) — VARCHAR2 — NOT NULL
  • Field (like) — NUMBER — NOT NULL

Untitled (user)

  • 유저ID (id) — VARCHAR2 — 기본 키 — NOT NULL
  • Key (portfolio_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Key (application_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • 유저PW (password) — VARCHAR2 — NOT NULL
  • 유저명 (name) — VARCHAR2 — NOT NULL
  • 유저나이 (age) — NUMBER — NOT NULL
  • 유저이메일 (email) — VARCHAR2 — NOT NULL
  • 유저휴대전화 (phone_number) — VARCHAR2 — NOT NULL
  • 유저주소 (address) — VARCHAR2 — NOT NULL
  • 유저희망직무 (job_preference) — VARCHAR2
  • 유저관심분야 (interests) — VARCHAR2
  • 유저기술셋 (stack) — VARCHAR2
  • 유저이미지정보 (profile_image) — VARCHAR2

Untitled (recruit)

  • Key (id) — NUMBER — 기본 키 — NOT NULL
  • Field (project_title) — VARCHAR2 — NOT NULL
  • Field (ppl_needed) — VARCHAR2 — NOT NULL
  • Field (contents) — VARCHAR2 — NOT NULL
  • Field (contact) — VARCHAR2 — NOT NULL
  • Field (project_field) — VARCHAR2 — NOT NULL
  • Field (exp_duration) — VARCHAR2 — NOT NULL
  • Field (location) — VARCHAR2 — NOT NULL
  • Field (type) — VARCHAR2 — NOT NULL
  • Field (tools) — VARCHAR2 — NOT NULL
  • Field (preference) — VARCHAR2 — NOT NULL
  • Field (status) — NUMBER — NOT NULL

Untitled (application)

  • Key (id) — NUMBER — 기본 키 — NOT NULL
  • Field (determination) — VARCHAR2 — NOT NULL

상세 프로젝트? (user_tracker)

  • Key (id) — NUMBER — 기본 키 — NOT NULL
  • 유저ID (user_id) — VARCHAR2 — 외래 키 → Untitled.유저ID — NOT NULL
  • Key (tracker_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Key (recruit_id) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Field (project_title) — VARCHAR2 — NOT NULL
  • Field (contents) — VARCHAR2 — NOT NULL
  • Field (participant) — VARCAHR2 — NOT NULL
  • Field2 (duration) — VARCHAR2 — NOT NULL
  • Field (tools) — VARCHAR2 — NOT NULL