MJ2 ERD
Tables (3)
post_file
- no — bigint — Primary key — NOT NULL
- target_no — bigint — NOT NULL
- filename — varchar(255) — NOT NULL
- filepath — varchar(255) — NOT NULL
- filesize — int
- filetype — varchar(50)
- created_at — timestamp
- extension — varchar(20)
- updated_at — timestamp
- savename — varchar(200) — NOT NULL
- save_status — varchar(4)
- target_type — varchar(4)
posts
- no — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- user_id — bigint — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- status — varchar(4)
- save_status — varchar(4)
- div — varchar(4)
users
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- email_verified_at — timestamp
- password — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- is_admin — varchar(4) — NOT NULL
- ph — varchar(15) — NOT NULL
- status — varchar(4)