개폼 | 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