JAPWeb ERD
Tables (10)
Board (보드)
- B_num (Primary) — Num — Primary key
- B_Title (Field) — Varchar
- B_Content (Field2) — Varchar
- B_check (Field3) — Varchar
- Day (Primary2) — Date — Foreign key → Calender.Day
- Stu_ID (Primary3) — Num — Foreign key → User.Stu_ID
- FIle_Name (Unique) — Varchar — Foreign key → File.FIle_Name
Calender (캘린더)
- Day (Primary) — Date — Primary key
- Event_Name (Field) — Varchar
- Category (Field3) — Varchar
- Stu_ID (Primary2) — Num — Foreign key → User.Stu_ID
Chat (채팅)
- Stu_ID (Primary) — Num — Foreign key → User.Stu_ID
- Friend_ID (Primary2) — Num — Foreign key → Contact.Friend_ID
Contact (친구목록)
- Friend_ID (Primary) — Num — Primary key
File (파일)
- File_Num (Primary) — Num — Primary key
- FIle_Name (Unique) — Varchar — Primary key
- File_Url (Field) — Varchar
- FIle_Size (Field2) — Num
Link (링크)
- Link_Url (Primary) — Varchar — Primary key
Memo (메모)
- Memo_Num (Primary) — Num — Primary key
- Memo_Title (Unique) — Varchar — Primary key — NOT NULL
- Memo_do (Field) — Varchar
ProjectGrid (프로젝트 그리드)
- PG_Num (Primary) — Num — Primary key
- PG_Name (Field) — Varchar
- PG_des (Field2) — Varchar
- FIle_Name (Unique) — Varchar — Foreign key → File.FIle_Name
- Memo_Title (Unique2) — Varchar — Foreign key → Memo.Memo_Title — NOT NULL
- Link_Url (Primary2) — Varchar — Foreign key → Link.Link_Url
Room (채팅방)
- Room_ID (Primary) — Num — Primary key
- RoomName — Varchar — NOT NULL
User (회원)
- Stu_ID (Primary) — Num — Primary key
- Email (Unique) — Varchar — Primary key
- Password (Field) — 비밀번호
- Phone (Field2) — Varcher