EverBrain

Tables (9)

Alarm (알림)

  • al_id (Key) — INT — Primary key — NOT NULL
  • u_id (수신유저아이디) — INT — Foreign key → Users.u_id — NOT NULL
  • content (내용) — TEXT
  • created_date (생성일) — DATETIME

Answer (답변)

  • u_id (유저아이디) — INT — Foreign key → Users.u_id — NOT NULL
  • q_id (질문아이디) — INT — Foreign key → Question.q_id — NOT NULL
  • content (내용) — VARCHAR(200)
  • created_date (생성일) — DATETIME
  • a_file (파일) — FILE

Feeds (피드)

  • f_id (Key) — INT — Primary key — NOT NULL
  • author_id (작성자) — INT — Foreign key → Users.u_id — NOT NULL
  • g_id (그룹아이디) — INT — Foreign key → Groups.g_id — NOT NULL
  • title (제목) — VARCHAR(50) — NOT NULL
  • content (내용) — TEXT
  • created_date (작성일) — DATETIME
  • modified_date (수정일) — DATETIME
  • feed_file (파일) — FILE
  • like (좋아요) — INT

G_mem (그룹멤버)

  • g_id (그룹아이디) — INT — Foreign key → Groups.g_id — NOT NULL
  • u_id (유저아이디) — INT — Foreign key → Users.u_id — NOT NULL
  • manager (관리자) — BOOL

Groups (그룹)

  • g_id (Key) — INT — Primary key — NOT NULL
  • mem_num (인원) — INT
  • g_code (코드) — VARCHAR(7)
  • created_date (생성일) — DATE
  • g_image (대표이미지) — IMAGE
  • g_name (그룹닉네임) — VARCHAR(10)

Question (질문)

  • q_id (Key) — INT — Primary key — NOT NULL
  • content (내용) — TEXT
  • created_date (날짜) — DATE

Users (유저)

  • u_id (Key) — INT — Primary key — NOT NULL
  • name (이름) — VARCHAR(10)
  • p_image (프로필사진) — FILE

like (좋아요)

  • f_id (Key) — INT — Foreign key → Feeds.f_id — NOT NULL
  • g_id (그룹아이디) — INT — Foreign key → Feeds.g_id — NOT NULL
  • u_id (유저아이디) — INT — Foreign key → Users.u_id — NOT NULL

user_profile (프로필)

  • u_id (유저아이디) — INT — Foreign key → Users.u_id — NOT NULL
  • p_image (프로필사진) — FILE
  • g_num (그룹수) — INT
  • alram_check (알림여부) — BOOL