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