lets say I have a users,posts and categories tables ..
- users table would have statuses like ( active, expired .. etc )
- posts table would have statuses like ( published, draft, archived .. etc )
- categories would also have different statuses
Is it bad if I did my tables like this:
users table:
- id
- name
- email
- password
- status_id
posts table:
- id
- title
- desc
- status_id
categories table:
- id
- title
- status_id
status table:
- id
- name ( active, expired , published, draft, archived .. etc )
Asked by rook
(151 rep)
Dec 16, 2017, 03:21 AM
Last activity: Jun 29, 2025, 06:07 AM
Last activity: Jun 29, 2025, 06:07 AM