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)