project_DB

Tables (6)

MANAGER

  • Man_Number — NUMBER(10)
  • Man_Name — VARCHAR2(9)
  • Man_ID — VARCHAR2(12)
  • Man_Password — VARCHAR2(12)

MAN_ROLE

  • Man_Name — VARCHAR2(9)
  • Mem_Manage — VARCHAR2(1)
  • Man_Number — NUMBER(10)

MEM_INFO

  • Name — VARCHAR2(9)
  • Nickname — VARCHAR2(10)
  • Phone — VARCHAR2(13)
  • Mem_ID — VARCHAR2(12)
  • Mem_Password — VARCHAR2(12)

MEM_MANAGEMENT

  • Mem_Name — VARCHAR2(9)
  • Mem_Manager — VARCHAR2(9)
  • DeleteMem — VARCHAR2(1)

NOTICE_BOARD

  • Mem_Writer — VARCHAR2(10)
  • W_Date — VARCHAR2(10)
  • Contents — VARCHAR2(100)
  • Correction — VARCHAR2(1)

NOTICE_MANAGE

  • Man_Writer — VARCHAR2(9)
  • W_Date — VARCHAR2(10)
  • Contents — VARCHAR2(100)
  • Correction — VARCHAR2(1)