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