runtime_ERD

Tables (13)

Follow (Untitled10)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • follower (Key3) — BIGINT — Foreign key → member.id — NOT NULL
  • following (Key2) — BIGINT — Foreign key → member.id — NOT NULL

access_authority (Untitled15)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • display_name (Field2) — VARCHAR — NOT NULL

authority_for_level (Untitled16)

  • id (Key3) — BIGINT — Primary key — NOT NULL
  • level_id (Key) — BIGINT — Foreign key → access_authority.id — NOT NULL
  • access_authority_id (Key2) — BIGINT — Foreign key → level.id — NOT NULL

banned_authority_for_account (unused) (Untitled17)

  • id (Key3) — BIGINT — Primary key — NOT NULL
  • access_authority_id (Key) — BIGINT — Foreign key → access_authority.id — NOT NULL
  • sccount_id (Key2) — BIGINT — Foreign key → member.id — NOT NULL

board (Untitled8)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • access_authority_id (Key2) — BIGINT — Foreign key → access_authority.id — NOT NULL

comment (Untitled5)

  • id (Key3) — BIGINT — Primary key — NOT NULL
  • account_id (Key) — BIGINT — Foreign key → member.id — NOT NULL
  • post_id (Key2) — BIGINT — Foreign key → post.id — NOT NULL
  • parent_id (Key32) — BIGINT — Foreign key → comment.id
  • body (Field) — BIGTEXT — NOT NULL

image (Untitled7)

  • id (Key) — BIGIINT — Primary key — NOT NULL
  • file_name (Field) — VARCHAR — NOT NULL
  • img_url (Field2) — VARCHAR — NOT NULL
  • post_id (Key2) — BIGINT — Foreign key → post.id — NOT NULL

level (Untitled9)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • number (Field2) — BIGINT — NOT NULL

login_event (Untitled12)

  • id (Key2) — BIGINT — Primary key — NOT NULL
  • user_agent (Field) — VARCHAR — NOT NULL
  • login_time (Field2) — DATETIME — NOT NULL
  • login_count (Field3) — BIGINT — NOT NULL
  • login_ip (Field4) — VARCHAR — NOT NULL
  • account_id (Key) — BIGINT — Foreign key → member.id — NOT NULL

member (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • level (Key3) — BIGINT — Foreign key → level.id — NOT NULL
  • user_id (Field) — VARCHAR — NOT NULL
  • password (Field2) — VARCHAR — NOT NULL
  • nickname (Field3) — VARCHAR — NOT NULL
  • created_at (Field4) — DATETIME — NOT NULL
  • last_login (Field5) — DATETIME — NOT NULL
  • login_count (Field6) — BIGINT — NOT NULL

note (Untitled14)

  • id (Key3) — BIGINT — Primary key — NOT NULL
  • message (Field) — BIGTEXT — NOT NULL
  • receiver_id (Key) — BIGINT — Foreign key → member.id — NOT NULL
  • sender_id (Key2) — BIGINT — Foreign key → member.id — NOT NULL
  • sent_at (Field3) — DATETIME — NOT NULL
  • id_read (Field2) — BOOLEAN — NOT NULL

post (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • account_id (Key2) — BIGINT — Foreign key → member.id — NOT NULL
  • board_id (Key3) — BIGINT — Foreign key → board.id — NOT NULL
  • title (Field) — VARCHAR — NOT NULL
  • content (Field2) — BIGTEXT — NOT NULL
  • likes (Field3) — BIGINT
  • createdAt (Field4) — DATETIME — NOT NULL

postlike (Untitled6)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • post_id (Key2) — BIGINT — Foreign key → post.id — NOT NULL
  • account_id (Key3) — BIGINT — Foreign key → member.id — NOT NULL