first
Tables (5)
mart (마트)
- martname (마트이름) — varchar2(20) — Primary key — NOT NULL
- gps_x (GPS_X축) — number(9,6)
- gps_y (GPS_Y축) — number(9,6)
- event (행사정보) — varchar2(50)
menu (요리)
- menuno (요리코드) — number(4) — Primary key — NOT NULL
- menuname (요리이름) — varchar2(20)
- time (요리시간) — varchar2(10)
- recipe (조리방법) — varchar2(1000)
- meterial_1 (준비물_1) — varchar2(20)
- meterial_2 (준비물_2) — varchar2(20)
- ... — ...
- meterial_20 (준비물_20) — varchar2(20)
meterial (준비물)
- metename (준비물명) — varchar2(20) — Primary key — NOT NULL
- kind (종류) — varchar2(9)
review (후기)
- rvno (후기번호) — number(8) — Primary key — NOT NULL
- userno (회원번호) — number(4)
- menuno (요리코드) — number(4)
- rvdate (등록일자) — date
- rvmemo (후기내용) — varchar2(1000)
- difficulty (난이도) — char(3)
userinfo (회원정보)
- userno (회원번호) — number(4) — Primary key — NOT NULL
- userid (회원아이디) — varchar2(10)
- userpw (회원비밀번호) — varchar2(10)
- hiredate (가입날짜) — date
- gps_x (GPS_X축) — number(9,6)
- gps_y (GPS_Y축) — number(9,6)
- meterial_1 (소유물_1) — varchar2(20)
- meterial_2 (소유물_2) — varchar2(20)
- ... — ...
- meterial_50 (소유물_50) — varchar2(20)