e

Tables (11)

follow (Untitled12)

  • idx (Key) — Primary key — NOT NULL
  • to_idx (Field)
  • from_idx (Field2)

influencer_member (Untitled3)

  • idx (Key) — Primary key — NOT NULL
  • member_idx (Key2) — Foreign key → member.Idx — NOT NULL
  • money (Field)

input (Untitled7)

  • idx (Key) — Primary key — NOT NULL
  • member_idx (Key2) — Foreign key → member.Idx — NOT NULL
  • amount (Field)
  • type (Field2)

member (Untitled2)

  • Idx (Key) — Primary key — NOT NULL
  • name (Field)
  • phone (Field2)
  • email (Field3)
  • nickname (Field4)
  • grade (Field5)
  • status (Field6)

menu (Untitled8)

  • idx (Key) — Primary key — NOT NULL
  • idx (Key2) — Foreign key → store.idx — NOT NULL
  • type (Field)
  • name (Field2)
  • description (Field3)
  • price (Field4)
  • category (Field5)
  • status (Field6)

post (Untitled6)

  • idx (Key) — Primary key — NOT NULL
  • member_idx (Key2) — Foreign key → member.Idx — NOT NULL
  • title (Field)
  • content (Field2)
  • image_url (Field3)
  • hearts (Field4)
  • views (Field5)

preminum_member (Untitled)

  • idx (Key) — Primary key — NOT NULL
  • member_idx (Key2) — Foreign key → member.Idx — NOT NULL
  • coupon (Field)
  • discount (Field2)

review (Untitled9)

  • idx (Key) — Primary key — NOT NULL
  • menu_idx (Key2) — Foreign key → menu.idx — NOT NULL
  • member_idx (Key3) — Foreign key → member.Idx — NOT NULL
  • content (Field)
  • taste_scroe (Field2)
  • mood_score (Field3)
  • service_score (Field4)
  • status (Field5)
  • views (Field6)
  • hearts (Field7)
  • image_url (Field8)

sns_auth (Untitled4)

  • idx (Key) — Primary key — NOT NULL
  • member_idx (Key2) — Foreign key → member.Idx — NOT NULL
  • snsChannel (Field)
  • snsUid (Field2)
  • meta (Field3)
  • status (Field4)

store (Untitled10)

  • idx (Key) — Primary key — NOT NULL
  • name (Field)
  • category (Field2)
  • location (Field3)
  • detail (Field4)
  • score (Field5)
  • image_url (Field6)
  • status (Field7)

token (Untitled11)

  • idx (Key) — Primary key — NOT NULL
  • member_idx (Key2) — Foreign key → member.Idx — NOT NULL
  • type (Field)
  • token (Field2)
  • status (Field3)
  • expiredAt (Field4)
  • lastUsedAt (Field5)