ㅁ
Tables (5)
center
- seq — int(11) — Primary key — NOT NULL
- center_id — varchar(30)
- center_name — varchar(60)
- updated — datetime
- level — int(11) — NOT NULL
- coach_count — int(11)
- client_count — int(11)
- active — char(1)
- regdate — datetime
- is_del — char(1)
center_coach
- seq — int(11) — Primary key — NOT NULL
- center_id — varchar(30)
- coach_id — varchar(30)
- is_owner — char(1)
- grade — varchar(30)
- regdate — datetime
- updated — datetime
- client_count — int(11)
- active_client_count — int(11)
- meta — text
- active — char(1)
- is_del — char(1)
- seq (seq2) — int(11) — Foreign key → center.seq — NOT NULL
member
- seq — int(11) — Primary key — NOT NULL
- mid — varchar(30) — NOT NULL
- email — varchar(50) — NOT NULL
- phone — varchar(30)
- name — varchar(30) — NOT NULL
- pass — varchar(120)
- level — varchar(30) — user / admin
- token — varchar(60)
- token_expire — datetime
- regdate — datetime
- updated — datetime
- is_del — char(1)
- birth — varchar(10)
- USING — NULL
- USING — NULL
payment
- seq — int(11) — NOT NULL
- regdate — datetime
- order_id — varchar(30) — NOT NULL
- product_id — varchar(30)
- member_id — varchar(30)
- currency — varchar(30)
- amount — decimal(10,2)
- mollie_payment_id — varchar(30)
- mollie_card_number — varchar(30)
- mollie_customer_id — varchar(30)
- mollie_status — varchar(30)
- mollie_sequence_type — varchar(30)
- mollie_subscription_id — varchar(30)
- is_del — char(1)
- seq — int(11) — NOT NULL
plan_coach
- seq — int(11) — Primary key — NOT NULL
- board) — ( seq int(11) — NOT NULL
- bid — varchar(30) — NOT NULL — plan_coach
- title — varchar(200) — NOT NULL — 식별 이름
- cate1 — varchar(60) — 결제 주기
- cate2 — varchar(60) — 원 가격
- cate3 — varchar(60) — NOT NULL — 달러 가격
- cate4 — varchar(60) — NOT NULL — 지급 클라이언트 수
- cate5 — varchar(60) — 지급 코치 수
- bid — varchar(30) — NOT NULL — plan_detail
- parent_id — int(11) — NOT NULL — 부모 ID
- title — varchar(200) — NOT NULL — 이름
- cate1 — varchar(60) — 언어
- center_id — varchar(30)
- order_id — varchar(60) — 주문번호
- product_id — int(11) — NOT NULL
- member_id — varchar(30)
- gubun — varchar(30)
- active — char(1)
- state — varchar(30)
- month_count — int(3)
- coach_count — int(3)
- client_count — int(3)
- sdate — date
- edate — date
- next_pay_date — date
- regdate — datetime
- updated — datetime
- mollie_customer_id — varchar(60)
- mollie_payment_id — varchar(60)
- mollie_subscription_id — varchar(60)
- is_del — char(1)