team table
Tables (12)
Untitled (MEMBER)
- Field (NO) — NUM — Primary key
- Field (E_NO) — VARCHAR2(20)
- Field (ID) — VARCHAR2(20)
- Field (PWD) — VARCHAR2(20)
- Field (NICK) — VARCHAR2(20)
- Field (NAME) — VARCHAR(20)
- Field (PHONE) — NUMBER
- Field (ADDRESS) — VARCHAR2(20)
- Field (EMAIL) — VARCHAR2(100)
- Field (GENDER) — CHAR(2)
- Field (ENROLL_DATE) — TIMESTAMP
- Field (MODIFY_DATE) — TIMESTAMP
- Field (DEL_YN) — CHAR(1)
Untitled (COMPANY)
- Field (NO) — VARCHAR2(20) — Primary key
- Field (NAME) — VARCHAR2(100)
- Field (CODE) — VARCHAR2(20)
- Field (D_NO) — VARCHAR2(20)
- Field (D_NAME) — VARCHAR2(100)
- Field (POSITION) — VARCHAR2(20)
Untitled (PROJECT)
- Key (NO) — NUM — Primary key — NOT NULL
- Field (NAME) — VARCHAR2(100)
- Field (KEY) — NOT NULLA
- Field (ACCESS) — CHAR(4)
- Field (E_NO) — VARCHAR2(20)
- Field (ENROLL_DATE) — TIMESTAMP
- Field (MODIFY_DATE) — TIMESTAMP
- Field (DEL_YN)
Untitled (ADD_MEMBER)
- Field (E_NO) — VARCHAR2(20)
- Field (P_NO) — NUM
- Field2 (S_NO) — NUM
- Field (C_NO) — NUM
- Field (R_NO) — NUM
Untitled (SCEDULE)
- Field (NO) — NUM — Primary key
- Field (TITLE) — VARCHAR2(100)
- Field (CONTENT) — VARCHAR2(100)
- Field (E_NO) — VARCHAR2(20)
- Field (START_DATE) — TIMESTAMP
- Field (END_DATE) — TIMESTAMP
- Field (ENROLL_DATE) — TIMESTAMP
- Field (MODIFY_DATE) — TIMESTAMP
- Field (PROJECT_NO) — NUM
Untitled (CUSTOMER)
- Field (NO) — NUM — Primary key
- Field (B_NO) — VARCHAR2(100)
- Field (NAME) — VARCHAR2(100)
- Field (B_NAME) — VARCHAR2(100)
- Field (EVENT) — VARCHAR2(100)
- Field (INDUSTRY) — VARCHAR2(100)
- Field (CALL_NO) — VARCHAR2(100)
- Field (ADDRESS) — VARCHAR2(100)
- Field (ENROLL_DATE) — TIMESTAMP
- Field (MODIFY_DATE) — TIMESTAMP
- Field (E_NO) — VARCHAR2(20)
- Field (S_NO) — NUM
- Field (START_DATE) — TIMESTAMP
- Field2 (END_DATE) — TIMESTAMP
Untitled (RESTAURANT)
- Field (NO) — NUM — Primary key
- Field (B_NO) — VARCHAR2(100)
- Field (NAME) — VARCHAR2(100)
- Field (B_NAME) — VARCHAR2(100)
- Field (INDUSTRY) — VARCHAR2(100)
- Field (CALL_NO) — VARCHAR2(100)
- Field (ADDRESS) — VARCHAR2(100)
- Field (OPEN) — NUM
- Field (ENROLL_DATE) — TIMESTAMP
- Field (MODIFY_DATE) — TIMESTAMP
- Field (OPEN_DATE) — TIMESTAMP
- Field (EDUCATION_DATE) — TIMESTAMP
- Field (E_NO) — VARCHAR2(20)
- Field (S_NO) — NUM
- Field (START_DATE) — TIMESTAMP
- Field (END_DATE) — TIMESTAMP
Untitled (ANNOUNCEMENTS)
- Key (NO) — NUM — Primary key — NOT NULL
- Field (TITLE) — VARCHAR2(100)
- Field (CONTENT) — VARCHAR2(200)
- Field (E_NO) — VARCHAR2(20)
- Field (TYPE) — VARCHAR2(20)
- Field (HIT) — NUM
- Field (OPTION) — VARCHAR2(20)
- Field (ENROLL_DATE) — TIMESTAMP
- Field (MODIFY_DATE) — TIMESTAMP
- Field (DEL_YN) — CHAR(1)
Untitled (BOARD)
- Key (NO) — NUM — Primary key — NOT NULL
- Field (TITLE) — VARCHAR2(100)
- Field (CONTENT) — VARCHAR2(100)
- Field (E_NO) — VARCHAR2(20)
- Field (HIT) — NUM
- Field (OPTION) — VARCHAR2(20)
- Field (ENROLL_DATE) — TIMESTAMP
- Field (MODIFY_DATE) — TIMESTAMP
Untitled (NOTE)
- Key (NO) — NUM — Primary key — NOT NULL
- Field (CONTENT) — VARCHAR2(100)
- Field (E_NO) — VARCHAR2(20)
- Field (R_E_NO) — VARCHAR2(20)
- Field (ENROLL_DATE) — TIMESTAMP
Untitled (COMMENT)
- Key (NO) — NUM — Primary key — NOT NULL
- Field (CONTENT) — VARCHAR2(100)
- Field (E_NO) — VARCHAR2(20)
- Field (BOARD_NO) — NUM
- Field (ENROLL_DATE) — TIMESTAMP
- Field2 (MODIFY_dATE) — TIMESTAMP
Untitled (ISSUE)
- Field (NO) — NUM — Primary key
- Field (TITLE) — VARCHAR2(200)
- Field (CONTENT) — VARCHAR2(100)
- Field (E_NO) — VARCHAR2(20)
- Field (OPTION) — VARCHAR2(100)
- Field (STATE) — VARCHAR2(100)
- Field — VARCHAR2(20)
- Field2 (START_DATE) — TIMESTAMP
- Field2 (END_DATE) — TIMESTAMP
- Field2 (ENROLL_DATE) — TIMESTAMP
- Field2 (MODIFY_DATE) — TIMESTAMPD
- Field2 (DEL_YN) — CHAR(1)
- Field2 (S_NO) — NUM