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