EveryPeople
Tables (10)
affiliation (CopyOfCopyOfUntitled)
- affiliation_id (Key) — BIGINT — Primary key — NOT NULL — (local, user, n:m 관계 해소)
- local_id (Key3) — INT — Foreign key → local.local_id — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL
comment (Untitled)
- comment_id (Key) — BIGINT — Primary key — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → post.post_id — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → user.user_id — NOT NULL
- is_deleted (Field) — VARCHAR(10) — NOT NULL — 삭제 여부(Y: [삭제 O] N: [삭제 X])
- update_time (Field2) — TIMESTAMP — NOT NULL — 삭제 여부(Y: [삭제 O] N: [삭제 X])
friend (Untitled5)
- follower_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL
- time (Field) — TIMESTAMP — NOT NULL — 팔로우한 날짜
local (CopyOfUntitled)
- local_id (Key) — INT — Primary key — NOT NULL
- local_name (Field) — VARCHAR(50) — NOT NULL
message (CopyOfCopyOf사용자)
- message_id (Key) — BIGINT — Primary key — NOT NULL
- message_room_id (Key2) — BIGINT — Foreign key → message_room.message_room_id — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → user.user_id — NOT NULL
- message (Field) — TEXT — NOT NULL
message_room (CopyOf사용자)
- message_room_id (Key) — BIGINT — Primary key — NOT NULL
- follower_id (Key2) — BIGINT — Foreign key → friend.follower_id — NOT NULL
- lastest_update_time (Field) — TIMESTAMP — NOT NULL — 최종 업데이트 시각
- creation_date (Field2) — TIMESTAMP — NOT NULL — 채팅방 생성일
notice_board (Untitled2)
- notice_board_id (Key) — INT — Primary key — NOT NULL — 게시판id
- affiliation_id (Key2) — BIGINT — Foreign key → affiliation.affiliation_id — NOT NULL — (local, user, n:m 관계 해소)
- update_time (Field) — TIMESTAMP — NOT NULL — 최종 업데이트 시각
post (Untitled3)
- post_id (Key) — BIGINT — Primary key — NOT NULL
- notice_board_id (Key2) — BIGINT — Foreign key → notice_board.notice_board_id — NOT NULL
- title (Field3) — VARCHAR(100) — NOT NULL
- post_time (Field) — TIMESTAMP — NOT NULL — 게시 시간
- update_time (Field5) — TIMESTAMP — NOT NULL — 최종 업데이트 시각
- content (Field2) — LONGTEXT — NOT NULL
- is_updated (Field6) — VARCHAR(10) — NOT NULL — 삭제 여부(Y: [삭제 O] N: [삭제 X])
- is_deleted (Field4) — VARCHAR(10) — NOT NULL — 삭제 여부(Y: [삭제 O] N: [삭제 X])
post_like (Untitled4)
- user_id (Key) — BIGINT — Foreign key → user.user_id — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → post.post_id — NOT NULL
- update_time (Field) — TIMESTAMP — NOT NULL — 최종 업데이트 시각
user (사용자)
- user_id (Key) — BIGINT — Primary key — NOT NULL
- user_password (Field6) — VARCHAR(255) — NOT NULL
- uers_email (Field7) — VARCHAR(50) — NOT NULL
- nick_name (Field5) — VARCHAR(50) — NOT NULL
- is_active (Field9) — VARCHAR(10) — NOT NULL — 계정 활성화 여부(Y: 활성화 N: 비활성화)
- introduction (Field4) — TEXT — NOT NULL — 소개글