okkot

Tables (17)

blocked_user (Untitled6)

    brand (Untitled4)

      coupon_log (Untitled15)

        delivery (Untitled3)

          delivery_plan_history (Untitled11)

            delivery_plan_log (Untitled12)

              favorite_shop (Untitled9)

                monthly_user_purchase_amount (Untitled17)

                  order_history (Untitled13)

                    point_log (Untitled14)

                      retail_store (Untitled5)

                        review (Untitled10)

                          role (Untitled2)

                          • Key — Primary key — NOT NULL
                          • id (Field)

                          user (Untitled)

                          • role_id (Key2) — Integer — Foreign key → role.Key — NOT NULL
                          • email (Field2) — STRING
                          • password (Field3) — STRING
                          • verify_token (Field4) — STRING
                          • name (Field5) — STRING
                          • nickName (Field6) — STRING
                          • phoneNumber (Field7) — STRING
                          • bcode (Field8) — STRING
                          • zone_code (Field9) — STRING
                          • address (Field10) — STRING
                          • adress_detail (Field11) — STRING
                          • gender (Field12) — CHAR
                          • create_ip (Field13) — STRING
                          • isCertificatedPhoneNumber (Field15) — BOOLEAN
                          • isCertifiedEmail (Field17) — TINYINY
                          • isAllowReciveSMS (Field14) — BOOLEAN
                          • isAllowReceiveEmail (Field16) — BOOLEAN
                          • secessionReason (Field18) — TEXT
                          • isBlocked (Field19) — Boolean
                          • remarkMessage (Field20) — Text
                          • isSignUpApproved (Field21) — Boolean
                          • delivery_id (Field22) — Integer
                          • birthDate (Field23) — STRING
                          • failed_login_attempts (Field24) — Integer
                          • lastLoginAt (Field25) — Date
                          • salt (Field26) — String
                          • uuid (Field27) — String

                          user_credit_card (Untitled16)

                            user_oauth (Untitled8)

                              user_to_membership (Untitled7)