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