order-mate

Tables (6)

Setting (Untitled3)

  • member_id (user_id) — Foreign key → member.member_id — NOT NULL
  • is_alarm (Field)

alarm (Untitled4)

  • member_id (user_id) — Foreign key → member.member_id — NOT NULL
  • created_at (Field) — NOT NULL
  • content (Field2) — NOT NULL

comment (Untitled2)

  • comment_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → post.post_id — NOT NULL
  • member_id (user_id) — Foreign key → member.member_id — NOT NULL
  • created_at (Field) — NOT NULL
  • content (Field2)

member (User)

  • member_id (user_id) — Primary key — NOT NULL
  • username (Field) — NOT NULL
  • password (Field2) — NOT NULL
  • name (Field3) — NOT NULL
  • nickname (Field4) — NOT NULL
  • gender (Field5) — NOT NULL
  • school (Field6)
  • major (Field7)

participation (Untitled5)

  • member_id (user_id) — Foreign key → member.member_id — NOT NULL
  • post_id (Key) — Foreign key → post.post_id — NOT NULL
  • role (Field) — NOT NULL

post (Untitled)

  • post_id (Key) — Primary key — NOT NULL
  • title (Field2) — NOT NULL
  • created_at (Field3) — NOT NULL
  • status (Field9) — NOT NULL
  • max_people_num (Field4) — NOT NULL
  • current_people_num (Field5) — NOT NULL
  • is_ anonymous (Field12) — NOT NULL
  • space_type (Field) — NOT NULL
  • content (Field11)
  • with_order_link (Field6)
  • pickup_space (Field7)
  • account_num (Field10)
  • estimated_order_time (Field8)