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