자바람개비

테이블 (3)

Notice (3)

  • Notice_ID (id) — NUMBER — 기본 키 — NOT NULL — Auto inclements
  • User_ID (Key) — VARCHAR2(20) — 외래 키 → User_Table.User_ID — NOT NULL
  • Notice_Title (title) — VARCHAR2(50)
  • Notice_Date (date) — DATE
  • Notice_Content (content) — VARCHAR2(500)

To-Do_Table (2)

  • User_ID (Key) — VARCHAR2(20) — 외래 키 → User_Table.User_ID — NOT NULL
  • Title (title) — VARCHAR2(30)
  • Start_Date (S_date) — DATE
  • End_Date (D_date) — DATE
  • MEMO (memo) — VARCHAR2(100)
  • Check (check) — BOOLEAN

User_Table (1)

  • User_ID (Key) — VARCHAR2(20) — 기본 키 — NOT NULL
  • User_NAME (name) — VARCHAR2(20)
  • User_PW (password) — VARCHAR2(12)
  • User_email (email) — VARCHAR2(30)
  • Access (access) — BOOLEAN
  • User_img (image) — VARCHAR2(100)