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