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