SpeedJobs
Tables (15)
anouncement (Untitled3)
- n_index (Key) — number — Primary key — NOT NULL
- username (Key2) — varchar2 — Foreign key → businiess member.username — NOT NULL
- career (Field) — varchar2
- period (Field2) — date
- tag (Field3) — varchar2
answer (Untitled5)
- q_index (Key) — number — Foreign key → question.q_index — NOT NULL
- id (Key2) — number — Foreign key → member.id — NOT NULL
- a_content (Field) — varchar2
- a_like (Field3) — number
- a_date (Field2)
attachment (Untitled10)
- file_name (Field)
- type (Field2)
- resume_id (Key2) — Foreign key → resume.resume_id — NOT NULL
businiess member (Untitled2)
- username (Key2) — varchar2 — Primary key — NOT NULL
- password (Field) — varchar2
- name (Field2) — varchar2
- scale (Field3) — varchar2
- logo (Field4)
- address (Field5) — varchar2
member (Untitled)
- id (Key) — number — Primary key — NOT NULL
- email (Field) — varchar2
- password (Field2) — varchar2
n_like (Untitled8)
- n_index (Key) — number — Foreign key → anouncement.n_index — NOT NULL
- id (Key2) — number — Foreign key → member.id — NOT NULL
n_tag (Untitled13)
- tag_id (Key2) — Foreign key → tag.tag_id — NOT NULL
- n_index (Key) — number — Foreign key → anouncement.n_index — NOT NULL
q_like (Untitled7)
- q_index (Key) — number — Foreign key → question.q_index — NOT NULL
- id (Key2) — number — Foreign key → member.id — NOT NULL
q_tag (Untitled12)
- q_index (Key) — number — Foreign key → question.q_index — NOT NULL
- tag_id (Key2) — Foreign key → tag.tag_id — NOT NULL
question (Untitled4)
- q_index (Key) — number — Primary key — NOT NULL
- id (Key2) — number — Foreign key → member.id — NOT NULL
- content (Field2) — varchar2
- view (Field3) — number
- date (Field)
r_open (Untitled14)
- resume_id (Key2) — Foreign key → resume.resume_id — NOT NULL
- choice (Key) — NOT NULL
r_tag (Untitled15)
- resume_id (Key2) — Foreign key → resume.resume_id — NOT NULL
- tag_id (Key) — Foreign key → tag.tag_id — NOT NULL
resume (Untitled6)
- resume_id (Key2) — Primary key — NOT NULL
- id (Key) — number — Foreign key → member.id — NOT NULL
- name (Field12)
- photh (Field)
- address (Field2)
- contact (Field3)
- birth (Field4)
- sex (Field5)
- cover_letter (Field7)
- education (Field9)
- career (Field10)
- gitgub_id (Field11)
submit (Untitled9)
- n_index (Key) — number — Foreign key → anouncement.n_index — NOT NULL
- resume_id (Key2) — Foreign key → resume.resume_id — NOT NULL
tag (Untitled11)
- tag_id (Key) — Primary key — NOT NULL
- description (Field)
- name (Field2)