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)