project

Tables (6)

UserTable (Untitled)

  • user_no (Key) — number — Primary key — NOT NULL
  • user_id (varchar2(50)) — varchar2(50) — NOT NULL
  • user_pw (Field2) — varchar2(50) — NOT NULL
  • user_name (Field) — varchar2(50) — NOT NULL
  • user_email (Field3) — varchar2(50) — NOT NULL
  • user_tel (Field4) — varchar2(50) — NOT NULL
  • regDate (Field6) — sysdate — NOT NULL
  • user_state (Field7) — varchar2(50) — NOT NULL

comm_board (CopyOfUntitled2)

  • comm_no (Key) — number — Primary key — NOT NULL
  • comm_category (varchar2(50)) — varchar2(50) — NOT NULL
  • comm_title (Field2) — varchar2(50) — NOT NULL
  • comm_content (Field) — varchar2(50) — NOT NULL
  • comm_views (Field3) — number — NOT NULL
  • regDate (Field4) — sysdate — NOT NULL
  • user_no (Field6) — number — NOT NULL
  • user_no (Key2) — number — Foreign key → UserTable.user_no — NOT NULL

job_offer (CopyOfUntitled)

  • offer_no (Key) — number — Primary key — NOT NULL
  • offer_category (varchar2(50)) — varchar2(50) — NOT NULL
  • offer_company (Field2) — varchar2(50) — NOT NULL
  • offer_title (Field) — varchar2(50) — NOT NULL
  • offer_career (Field3) — varchar2(50) — NOT NULL
  • offer_tools (Field4) — varchar2(50) — NOT NULL
  • offer_type (Field6) — varchar2(50) — NOT NULL
  • offer_salary (Field7) — number — NOT NULL
  • offer_content (Field5) — varchar2(50)
  • regDate (Field8) — sysdate
  • user_no (Field9) — number
  • user_no (Key2) — number — Foreign key → UserTable.user_no — NOT NULL

job_seeker (CopyOfCopyOfUntitled)

  • seeker_no (Key) — number — Primary key — NOT NULL
  • seeker_category (varchar2(50)) — varchar2(50) — NOT NULL
  • seeker_title (Field2) — varchar2(50) — NOT NULL
  • seeker_career (Field) — varchar2(50) — NOT NULL
  • seeker_tools (Field3) — varchar2(50) — NOT NULL
  • seeker_type (Field4) — varchar2(50) — NOT NULL
  • seeker_case (Field6) — varchar2(50) — NOT NULL
  • seeker_min (Field7) — number — NOT NULL
  • seeker_portofolio (Field5) — varchar2(50) — NOT NULL
  • regDate (Field8) — sysdate — NOT NULL
  • user_no (Field9) — number — NOT NULL
  • user_name (Field10) — varchar2(50) — NOT NULL
  • user_no (Key2) — number — Foreign key → UserTable.user_no — NOT NULL

store_order (CopyOfCopyOfCopyOfUntitled2)

  • order_no (Key) — number — Primary key — NOT NULL
  • user_no (varchar2(50)) — number — NOT NULL
  • product_no (Field2) — number — NOT NULL
  • regDate (Field) — sysdate — NOT NULL
  • user_no (Key2) — number — Foreign key → UserTable.user_no — NOT NULL
  • product_no (Key3) — number — Foreign key → store_product.product_no — NOT NULL

store_product (CopyOfCopyOfUntitled2)

  • product_no (Key) — number — Primary key — NOT NULL
  • product_category (varchar2(50)) — varchar2(50) — NOT NULL
  • product_img (Field2) — varchar2(50) — NOT NULL
  • product_title (Field) — varchar2(50) — NOT NULL
  • product_content (Field3) — varchar2(50) — NOT NULL
  • product_price (Field4) — number — NOT NULL
  • product_status (Field6) — number — NOT NULL