20250324
Tables (7)
adm
- adm_id — VARCHAR(20)
- adm_pwd — VARCHAR(20) — NOT NULL
- adm_lev — INT — NOT NULL
board
- board_id — int
- board_title — varchar(100)
- board_content — varchar(300)
- board_author — varchar(30)
- board_hit — int
- board_rdate — datetime
- board_udate — datetime
cart
- cart_id — INT
- cust_id — VARCHAR(20)
- item_id — INT
- cart_cnt — INT
- cart_rdate — datetime
cust
- cust_id — VARCHAR(20)
- cust_pwd — VARCHAR(20) — NOT NULL
- cust_name — VARCHAR(30) — NOT NULL
item
- item_id — INT
- item_name — VARCHAR(30) — NOT NULL
- item_price — INT — NOT NULL
- item_imgname — VARCHAR(40)
- item_rdate — datetime
marker
- marker_id — INT
- marker_title — VARCHAR(30)
- marker_target — VARCHAR(30)
- marker_lat — FLOAT
- marker_lng — FLOAT
- marker_img — VARCHAR(30)
- marker_loc — CHAR(1)
sales
- sales_id — int
- sales_rdate — DATE
- sales_price — INT
- sales_gender — CHAR(1)