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 — 소개글