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)