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