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)