lunching
Tables (7)
client
- id — varchar(100) — Primary key — NOT NULL — 유니크아이디
- deliveryline_id — varchar(100) — Foreign key → deliveryline.id — NOT NULL — 유니크 아이디
- company_id — varchar(100) — Foreign key → company.id — NOT NULL
- name — varchar(100) — 제목
- code — varchar(100) — 카테고리
- address — varchar(500)
- phone — varchar(100)
- deleted_at — timestamp
- updated_at — timestamp — 변경일자
- created_at — timestamp — 생성일자
company
- id — varchar(100) — Primary key — NOT NULL
- name — varchar(100)
- domain — varchar(100)
- default_price — varchar(100)
customer
- id — varchar(100) — Primary key — NOT NULL — 유니크아이디
- client_id — varchar(100) — Foreign key → client.id — NOT NULL — 유니크아이디
- company_id — varchar(100) — Foreign key → company.id — NOT NULL
- sign_type — char(2) — 가입
- sns_id — varchar(100) — sns
- name — varchar(30) — 이름
- phone_number — varchar(20) — 전화번호
- email — varchar(100) — 이메일
- agree_service — boolean — 프로필
- agree_private — boolean
- agree_ad — boolean — 비밀번호
- user_type — varchar(20)
- option — varchar(100)
- created_at — timestamp — NOT NULL — 생성일
- updated_at — timestamp
- deleted_at — timestamp — NOT NULL — 회원탈퇴
deliveryline
- id — varchar(100) — Primary key — NOT NULL — 유니크 아이디
- line — varchar(50) — NOT NULL — 유저아이디
- deliver_date — varchar(50)
- name — varchar(50)
option
- id — varchar(100) — Primary key — NOT NULL — 유니크 아이디
- client_id — varchar(100) — Foreign key → client.id — NOT NULL — 유니크아이디
- title — varchar(50) — NOT NULL — 유저아이디
order
- id — varchar(100) — Primary key — NOT NULL — 유니크 아이디
- user_id — varchar(100) — Foreign key → customer.id — NOT NULL — 유니크아이디
- product_id — varchar(100) — Foreign key → product.id — NOT NULL — 유니크 아이디
- order_date — varchar(50) — NOT NULL — 좋아하는지
- order_status — varchar(100)
- count — int(11)
- cancel_status — varchar(100)
- description — varchar(100)
- created_at — timestamp — NOT NULL — 생성일
- updated_at — timestamp
- deleted_at — timestamp
product
- id — varchar(100) — Primary key — NOT NULL — 유니크 아이디
- client_id — varchar(100) — Foreign key → client.id — NOT NULL — 유니크아이디
- company_id — varchar(100) — Foreign key → company.id — NOT NULL
- category_index — int(11) — NOT NULL — 좋아하는지
- title — varchar(50) — NOT NULL — 유저아이디
- price — varchar(50)
- vat — boolean
- order_date — varchar(50)
- created_at — timestamp — NOT NULL — 생성일
- updated_at — timestamp
- deleted_at — timestamp