spring project

Tables (8)

Admin (tbl_admin)

  • id — integer — Primary key — NOT NULL
  • username (아이디) — varchar(50)
  • password (비밀번호) — varchar(120)
  • company (회사명) — varchar(120)
  • reg_date (생성 날짜) — datetime
  • mod_date (수정 날짜) — datetime

Category (tbl_category)

  • id — integer — Primary key — NOT NULL
  • admin_id — integer — Foreign key → Admin.id — NOT NULL
  • category (카테고리) — varchar(20)
  • reg_date (생성 날짜) — datetime
  • mod_date (수정 날짜) — datetime

Detail (tbl_detail)

  • id — integer — Primary key — NOT NULL
  • menu_id — integer — Foreign key → Menu.id — NOT NULL
  • detail (세부 사항) — varchar(50)
  • price (가격) — integer
  • reg_date (생성 날짜) — datetime
  • mod_date (수정 날짜) — datetime

Img (tbl_img)

  • id — integer — Primary key — NOT NULL
  • menu_id — integer — Foreign key → Menu.id — NOT NULL
  • url (이미지 url) — varchar(120)
  • reg_date (생성 날짜) — datetime
  • mod_date (수정 날짜) — datetime

Log (tbl_log)

  • id — integer — Primary key — NOT NULL
  • admin_id (어드민 id) — integer
  • state (상태) — enum
  • price (가격) — integer
  • payment_method (결제 방법) — enum
  • reg_date (생성 날짜) — datetime
  • mod_date (수정 날짜) — datetime

LogDetail (tbl_log_detail)

  • id — integer — Primary key — NOT NULL
  • log_menu_id (메뉴 로그 id) — integer — Foreign key → LogMenu.id — NOT NULL
  • detail (세부 사항) — varchar(50)
  • price (가격) — integer
  • reg_date (생성 날짜) — datetime
  • mod_date (수정 날짜) — datetime

LogMenu (tbl_log_menu)

  • id — integer — Primary key — NOT NULL
  • log_id (로그 id) — integer — Foreign key → Log.id — NOT NULL
  • menu (메뉴) — varchar(40)
  • price (가격) — integer
  • reg_datge (생성 날짜) — datetime
  • mod_date (수정 날짜) — datetime

Menu (tbl_menu)

  • id — integer — Primary key — NOT NULL
  • category_id (catagory_id) — integer — Foreign key → Category.id — NOT NULL
  • menu (메뉴 명) — varchar(40)
  • price (가격) — integer
  • state (상태) — enum
  • reg_date (생성 날짜) — datetime
  • mod_date (수정 날짜) — datetime