okkot
Tables (17)
delivery_plan_history (Untitled11)
delivery_plan_log (Untitled12)
favorite_shop (Untitled9)
monthly_user_purchase_amount (Untitled17)
order_history (Untitled13)
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_to_membership (Untitled7)