covid

Tables (9)

consum_pattern

  • appliance (applience) — decimal
  • book — decimal
  • fashion — decimal
  • food — decimal
  • life — decimal
  • service — decimal
  • ect — decimal
  • Field

covid_blue

  • worry — decimal
  • fear — decimal
  • anger — decimal
  • rage — decimal
  • lethargy — decimal
  • lonely — decimal
  • pride — decimal
  • relief — decimal
  • date — date

koreawine (서울장수)

  • date (날짜) — date — Primary key — NOT NULL
  • sales (총매출액) — decimal
  • sales_profit (매출이익) — decimal
  • operate_profit (영업이익) — decimal
  • net_profit (당기순이익) — decimal

ksdb (국순당)

  • date (날짜) — date — Primary key — NOT NULL
  • sales (총매출액) — decimal
  • sales_profit (매출이익) — decimal
  • operate_profit (영업이익) — decimal
  • net_profit (당기순이익) — decimal

lotte (롯데칠성)

  • date (날짜) — date — Primary key — NOT NULL
  • sales (총매출액) — decimal
  • sales_profit (매출이익) — decimal
  • operate_profit (영업이익) — decimal
  • net_profit (당기순이익) — decimal

muhak (무학)

  • date (날짜) — date — Primary key — NOT NULL
  • sales (총매출액) — decimal
  • sales_profit (매출이익) — decimal
  • operate_profit (영업이익) — decimal
  • net_profit (당기순이익) — decimal

ob (오비맥주)

  • date (날짜) — date — Primary key — NOT NULL
  • sales (총매출액) — decimal
  • sales_profit (매출이익) — decimal
  • operate_profit (영업이익) — decimal
  • net_profit (당기순이익) — decimal

wine_channel (채널 별 와인 판매량)

  • date (날짜) — date — Primary key — NOT NULL
  • department (백화점) — decimal
  • mart (대형마트) — decimal
  • convenience (편의점) — decimal

wine_type (종류 별 와인 판매량)

  • date (날짜) — date — Primary key — NOT NULL
  • date (날짜2) — date — Foreign key → wine_channel.date — NOT NULL
  • red (레드와인) — decimal
  • white (화이트와인) — decimal
  • sparkling (스파클링와인) — decimal
  • natural (네추럴와인) — decimal