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