bookstore

Tables (3)

Order (주문)

  • order_date (주문날짜) — now()
  • order_value (주문금액) — int
  • order_status (주문상태) — enum
  • user_id (주문자 _id)

Untitled

    User (회원)

    • user_id (Key) — varchar — Primary key — NOT NULL
    • user_status (회원상태) — varchar
    • user_email (회원email) — varchar
    • user_join_date (가입일) — now()
    • user_rank (회원등급) — varchar
    • user_name (회원이름) — varchar
    • user_contact (연락처)
    • user_access_date (최근접속일) — now()
    • user_join_status (회원가입상태) — varchar