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)