liner_feed

Tables (5)

PARENT (MEMBER)

  • Key (member_seq) — bigint — Primary key — NOT NULL — member seq
  • Field (member_id) — varchar(30) — NOT NULL — 회원 아이디
  • Field (user_name) — varchar(30) — NOT NULL — 닉네임
  • Field (password) — varchar(200) — NOT NULL — 비밀번호
  • Field (email) — varchar(200) — email
  • Field (created_datetime) — datetime — NOT NULL — 데이터 생성일
  • Field (updated_datetime) — datetime — NOT NULL — 데이터 수정일

Untitled (HOMEPAGE)

  • Key (homepage_seq) — bigint — Primary key — NOT NULL — homepage_seq
  • Field (url) — varchar(1000) — NOT NULL — 홈페이지 url
  • Field (title) — varchar(1000) — NOT NULL — 홈페이지 타이틀
  • Field (created_datetime) — datetime — NOT NULL — 데이터 생성일
  • Field (updated_datetime) — datetime — NOT NULL — 데이터 수정일

Untitled (HIGHLIGHT)

  • Key (highlight_seq) — bigint — Primary key — NOT NULL — highlight_seq
  • Key (member_seq) — bigint — Foreign key → PARENT.Key — NOT NULL — member seq
  • Key (homepage_seq) — bigint — Foreign key → Untitled.Key — NOT NULL — homepage_seq
  • Field (bar_color) — varchar(20) — NOT NULL — 하이라이트 컬러
  • Field (higlight_text) — longtext — 하이라이트 문장
  • Field (higlight_date) — date — NOT NULL — 하이라이트 생성일
  • Field (highlight_time) — time — NOT NULL — 하이라이트 생성시간
  • Field (open_range) — varchar(20) — NOT NULL — 공개범위
  • Field (created_datetime) — datetime — NOT NULL — 데이터 생성일
  • Field (updated_datetime) — datetime — NOT NULL — 데이터 수정일

Untitled (MENTION)

  • Key (mention_seq) — bigint — Primary key — NOT NULL — mention_seq
  • Key (highlight_seq) — bigint — Foreign key → Untitled.Key — NOT NULL — highlight_seq
  • Field (created_datetime) — datetime — NOT NULL — 데이터 생성일
  • Field (updated_datetime) — datetime — NOT NULL — 데이터 수정일

Untitled (MENTION_MEMBER)

  • Key (seq) — Primary key — NOT NULL
  • Key (mention_seq) — bigint — Foreign key → Untitled.Key — NOT NULL — mention_seq
  • Key (member_seq) — bigint — Foreign key → PARENT.Key — NOT NULL — member seq