모두의 교사

테이블 (7)

Agency (agency)

  • agency_no (Key) — number — 기본 키 — NOT NULL
  • agency_name (Field) — varchar2(30)
  • agency_address (Field2) — varchar2(50)
  • agency_score (Field3) — number

Incruit (incruit)

  • incruit_no (Key2) — number — 기본 키 — NOT NULL
  • user_no (Key) — number — 외래 키 → User.user_no — NOT NULL
  • incruit_title (Field2) — varchar2(50)
  • incruit_content (Field3) — varchar2(500)
  • incruit_position (Field4) — varchar2(30)
  • incruit_update (Field5) — date
  • incruit_deadline (Field6) — date

Review (review)

  • reivew_no (Key) — number — 기본 키 — NOT NULL
  • user_no (Key2) — number — 외래 키 → User.user_no — NOT NULL
  • review_update (Field) — date
  • review_score (Field2) — number
  • task (Field3) — varchar2(500)
  • boss (Field4) — varchar2(500)
  • relation (Field5) — varchar2(500)
  • salary (Field6) — varchar2(50)
  • etc (Field7) — varchar2(500)

User (users)

  • user_no (Key) — number — 기본 키 — NOT NULL
  • user_id (Field) — varchar2(30)
  • user_pwd (Field2) — varchar2(30)
  • user_phone (Field3) — varchar2(30)
  • user_mail (Field4) — varchar2(50)
  • user_name (Field5) — varchar2(20)
  • user_address (Field6) — varchar2(300)
  • user_type (Field7) — varchar2(20)
  • company_name (Field8) — varchar2(50)
  • company_tel (Field10) — varchar2(30)

comment

  • comment_no (Key) — number — 기본 키 — NOT NULL
  • comunity_no (Key2) — number — 외래 키 → comunity.comunity_no — NOT NULL
  • comment_content (Field2) — varchar2(500)
  • comment_update (Field3) — date

comunity (community)

  • comunity_no (Key2) — number — 기본 키 — NOT NULL
  • user_no (Key) — number — 외래 키 → User.user_no — NOT NULL
  • comunity_update (Field) — date
  • comunity_title (Field2) — varchar2(50)
  • comunity_content (Field3) — varchar2(500)
  • comunity_count (Field4) — number
  • comunity_file (Field5) — varchar2(50)
  • category_name (Field6) — varchar2(50)

liked

  • liked_no (Key) — number — 기본 키 — NOT NULL
  • incruit_no (Key2) — number — 외래 키 → Incruit.incruit_no — NOT NULL
  • liked_count (Field) — number