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