U&I Company Prj
Tables (3)
TB_dev (Untitled)
- userNo (Key) — number — Foreign key → TB_user.userNo — NOT NULL
- jobType (Field3) — varchar2(20)
TB_notice (Untitled3)
- postNo (Key) — number — Primary key — NOT NULL
- userNo (Key2) — number — Foreign key → TB_user.userNo — NOT NULL
- title (Field) — varchar2(100)
- content (Field2) — varchar2(500)
- writer (Field3) — varchar2(30)
- cDate (Field4) — date
- eDate (Field5) — number
- views (Field6) — number
TB_user (Untitled2)
- userNo (Key) — number — Primary key — NOT NULL
- id (Filed) — varchar2(30)
- name (Field2) — varchar2(50)
- email (Field3) — varchar2(100)
- auth (Field) — varchar2(20)
- password (Field4) — varchar2(40)