Board
Tables (6)
Admins (Untitled4)
- admin_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → Users.user_id — NOT NULL
Boards
- board_id (Key) — Primary key — NOT NULL
- admin_id (Key2) — Foreign key → Admins.admin_id — NOT NULL
Comments
- comments_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → Users.user_id — NOT NULL
- post_id (Key3) — Foreign key → Posts.post_id — NOT NULL
- content_comments (Field)
- created_at_comments (Field2)
- updated_at_comments (Field3)
Post_img
- image_id (Key) — Primary key — NOT NULL
- post_id (Key2) — Foreign key → Posts.post_id — NOT NULL
- original_name (Field)
- stored_name (Field2)
- image_url (Field3)
- created_at_img (Field4)
Posts (Untitled2)
- post_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → Users.user_id — NOT NULL
- board_id (Key3) — Foreign key → Boards.board_id — NOT NULL
- title (Field)
- content_posts (Field2)
- price (Field3)
- category (Field4)
- location (Field5)
- status (Field6)
- created_at_posts (Field7)
Users
- user_id (Key) — Primary key — NOT NULL
- user_name (Field)
- password (Field2)
- nickname (Field3)
- role (Field4)
- phone (Field5)