test

Tables (9)

tbbell

  • no — bigint(20) — Primary key — NOT NULL
  • table_no — smallint(6)
  • store_no — bigint(20) — Foreign key → tbstore.no — NOT NULL

tbcommute

  • user_id — varchar(40) — Foreign key → tbuser.id — NOT NULL
  • go_to — datetime
  • leave_to — datetime

tblocation

  • no — bigint(20) — Primary key — NOT NULL
  • locate — varchar(20)

tbreq

  • no — bigint(20) — Primary key — NOT NULL
  • service_no — bigint(20) — Foreign key → tbservice.no — NOT NULL
  • division — enum('C', 'O', 'T')
  • reg_dt — datetime
  • reply_yn — enum('Y', 'N')
  • reply_dt — datetime
  • close_dt — datetime
  • location — bigint(20) — Foreign key → tblocation.no
  • weather_no — bigint(20) — Foreign key → tbweather.no
  • gender — tinyint(2) — 1: 남자 2: 여자
  • age_range — varchar(30)
  • rate — float
  • user_id — varchar(40) — Foreign key → tbuser.id

tbreq_order

  • no — bigint(20) — Foreign key → tbreq.no — NOT NULL
  • menu — varchar(50)
  • type — enum('M', 'D', 'B', 'A') — 구분(M: Meal 식사류, D: Desert 디저트류, B: Bar snack 안주류, A: Alcohol 주류)
  • age — int(11)
  • gender — tinyint(4) — 1: 남자 2: 여자
  • age_range — varchar(30)

tbservice

  • no — bigint(20) — Primary key — NOT NULL
  • store_no — bigint(20) — Foreign key → tbstore.no — NOT NULL
  • bell_no — bigint(20) — Foreign key → tbbell.no
  • enter_dt — datetime
  • exit_dt — datetime

tbstore

  • no — bigint(20) — Primary key — NOT NULL
  • name — varchar(255)
  • store_type — varchar(255) — Hotel, 24시 식당, 점심~저녁, 저녁
  • menu_type — varchar(255) — 한식, 양식, 중식, 일식, 퓨전(주점)
  • country — varchar(255)
  • addr — bigint(20) — Foreign key → tblocation.no — NOT NULL
  • staff_cnt — int(11)
  • store_size — varchar(50)

tbuser

  • id — varchar(40) — Primary key — NOT NULL
  • name — varchar(40)
  • division — enum('A','O','D','C','M','S')
  • store_no — bigint(20) — Foreign key → tbstore.no
  • del_yn — enum('Y','N')
  • reg_dt — datetime
  • mod_dt — datetime

tbweather

  • no — bigint(20) — Primary key — NOT NULL
  • location — bigint(20) — Foreign key → tblocation.no — NOT NULL
  • date — datetime — NOT NULL
  • temperature — varchar(50) — NOT NULL
  • rain — varchar(50)
  • snow — varchar(50)
  • cloud — varchar(50) — NOT NULL
  • humidity — varchar(50)
  • dust — varchar(50)