T_USER

Tables (8)

Address (address)

  • address_id (Key) — long — Primary key — NOT NULL
  • customer_id (FK) — long — Foreign key → Customer.customer_id — NOT NULL
  • address_status (Field1) — char(1)
  • delivery_name (Field2) — varchar(20) — 한글 및 영문 소문자
  • zip_code (Field3) — varchar
  • address (Field4) — varchar
  • additional_address (Field5) — varchar
  • delivery_contact (Field7) — varchar
  • delivery_access (Field6) — varchar
  • registerd_at (Field8) — timestamp
  • registerd_id (Field9) — long
  • modified_at (Field10) — timestamp
  • modifier_id (Field11) — long

Customer (customer)

  • customer_id (Key) — long — Primary key — NOT NULL
  • customer_status (Field1) — char(1) — 일반회원: U, 휴면회원: R, 탈퇴회원: D, 불량회원: B
  • email (Field2) — varchar(40) — 로컬 형식 : 영문 소문자, 숫자, 특수문자 허용특수문자: -_
  • password (Field3) — varchar(70) — 암호화: bcrypt 띄어쓰기 불포함
  • full_name (Field4) — varchar(20) — 한글 또는 영문 소문자
  • nickname (Field5) — varchar(20) — 한글 또는 영문 소문자
  • phone (Field6) — varchar(14) — 국가번호포함
  • last_login (Field11) — timestamp
  • registerd_at (Field7) — timestamp
  • registerd_id (Field8) — long
  • modified_at (Field9) — timestamp
  • modifier_id (Field10) — long

CustomerCoupon (customer_coupon)

  • customer_id (Key) — long — Foreign key → Customer.customer_id — NOT NULL
  • coupon_type (Field2) — varchar
  • coupon_status (Field9) — char(1)
  • expiration_period (Field) — varchar
  • modified_at (Field7) — timestamp
  • modifier_id (Field8) — long

CustomerPoint (Customer_point)

  • customer_id (Key) — long — Foreign key → Customer.customer_id — NOT NULL
  • point (Field1) — int
  • point_detail (Field2) — varchar
  • expiration_period (Field) — varchar
  • modified_at (Field7) — timestamp
  • modifier_id (Field8) — long

MembershipGrade (membership_grade)

  • customer_id (Key) — long — Foreign key → Customer.customer_id — NOT NULL
  • grade (Field7) — varchar(10) — VIP , Gold, Silver, Bronze
  • total_order_amount (Field1) — int — 등급 산정 이후 현재까지 총 주문금액
  • modified_at (Field) — timestamp
  • modifier_id (Field2) — long

Terms (terms)

  • terms_id (Key) — long — Primary key — NOT NULL
  • terms_code (Field10) — char(4)
  • terms_status (Field1) — char(1) — 등록(대기): W 미승인: N 승인(사용): A 미사용: U
  • terms_version (Field2) — float(3)
  • expiration_period (Field3) — varchar
  • registerd_at (Field5) — timestamp
  • registerd_id (Field6) — long
  • modified_at (Field7) — timestamp
  • modifier_id (Field8) — long
  • terms_name (Field9) — varchar

TermsAgreement (terms_agreement)

  • customer_id (Key) — long — Foreign key → Customer.customer_id — NOT NULL
  • terms_id (Key2) — long — Foreign key → Terms.terms_id — NOT NULL
  • agreement_status (Field3) — char(1)
  • registerd_at (Field5) — timestamp
  • registerd_id (Field6) — long
  • modified_at (Field7) — timestamp
  • modifier_id (Field8) — long

TermsFile (terms_file)

  • file_id (Key) — varchar — Primary key — NOT NULL
  • terms_id (FK) — long — Foreign key → Terms.terms_id — NOT NULL
  • file_name (Field9) — varchar
  • file_path (Field3) — varchar
  • file_size (Field5) — timestamp
  • file_extension (Field6) — varchar
  • registerd_at (Field7) — timestamp
  • registerd_id (Field8) — long
  • modified_at (Field) — timestamp
  • modifier_id (Field2) — long