D클래스2조

테이블 (9)

Aizi_Combination

  • Room_Code — Varchar2(50) — 기본 키 — NOT NULL
  • Active — Varchar2(50) — NOT NULL
  • Combination — varchar2(3000)
  • Selected — Number

Aizi_Keyword

  • Room_Code — varchar2(50) — 외래 키 → Aizi_Roominfo.Room_Code — NOT NULL
  • Stage — Number
  • Keyword — Varchar2(3000)
  • Keyword_Id — Varchar2(100)
  • Selected — Number

Aizi_Messagebox

  • User_Id — Varchar2(50) — 외래 키 → Aizi_User.User_Id — NOT NULL
  • Msg_No — Number — NOT NULL
  • Message — Varchar2(1000)

Aizi_Participant

  • Room_Code — varchar2(50) — 외래 키 → Aizi_Roominfo.Room_Code
  • User_Id — 외래 키 → Aizi_User.User_Id

Aizi_Roominfo

  • Room_Code — varchar2(50) — 기본 키 — NOT NULL
  • Key — 외래 키 → Mindmap.Room_Code — NOT NULL
  • Room_Code (Room_Code2) — Varchar2(50) — 외래 키 → Aizi_Combination.Room_Code — NOT NULL
  • Room_Leader — varchar2(50) — NOT NULL
  • Room_Mtd — varchar2(50) — NOT NULL
  • Room_Type — varchar2(50) — NOT NULL
  • Room_Topic — Varchar2(500) — NOT NULL
  • Room_Ppl — varchar2(10) — NOT NULL
  • Room_Date — Varchar2(30) — NOT NULL
  • Room_Recent — Date — NOT NULL
  • Room_Halt — Varchar2(3) — NOT NULL
  • Room_Delete — Varchar2(3) — NOT NULL
  • Room_Seq — Number — NOT NULL

Aizi_Storyboarding

  • Room_Code — Varchar2(50) — 기본 키 — NOT NULL
  • Dnd — Clob
  • Halt — Clob
  • Idea — Clob

Aizi_User

  • User_Id — varchar2(50) — 기본 키
  • User_Pw — varchar2(100) — NOT NULL
  • User_Name — varchar2(50) — NOT NULL
  • User_Email — varchar2(100) — NOT NULL
  • User_Company — varchar2(100) — NOT NULL
  • User_Department — varchar2(100) — NOT NULL
  • User_Delete — varchar2(3) — NOT NULL
  • User_Indate — date — NOT NULL
  • User_Noti — Number

Mindmap (Untitled2)

  • Room_Code — Varchar2(50) — 기본 키 — NOT NULL
  • Node_Id — Varchar2(100)
  • Keyword — Varchar2(3000)
  • Keyword_Id — Varchar2(100)
  • Selected — Number

Sixthreefive

  • Room_Id (Room_Id2) — varchar2(50) — 외래 키 → Aizi_Roominfo.Room_Code — NOT NULL
  • User_Id — varchar2(50) — 외래 키 → Aizi_User.User_Id
  • Six_Text1 — Varchar2(1000) — NOT NULL
  • Six_Text2 — Varchar2(1000) — NOT NULL
  • Six_Text3 — Varchar2(1000) — NOT NULL