모두의 교사
테이블 (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