board
Tables (8)
address (주소)
- id (주소) — bigint — Primary key — NOT NULL
- id (글쓴이ID) — bigint — Foreign key → author.id — NOT NULL
- nation (국가) — varchar(255) — NOT NULL
- city (도시) — varchar(255) — NOT NULL
author (회원(글쓴이))
- id (글쓴이ID) — bigint — Primary key — NOT NULL
- email (이메일) — varchar(255) — NOT NULL
- name (이름) — varchar(255)
order (주문내역)
- ID (Key) — bigint — Primary key — NOT NULL
- order_name (주문자이름) — bigint — Foreign key → user.ID — NOT NULL
- order_product (주문상품) — bigint — NOT NULL
- order_price (주문총금액) — bigint — NOT NULL
- order_time (주문시간) — datetime — NOT NULL
order_detail (상세주문)
- ID (상세주문ID) — bigint — Primary key — NOT NULL
- product_ID (상품ID) — bigint — Foreign key → product.ID — NOT NULL
- order_ID (주문ID) — bigint — Foreign key → order.ID — NOT NULL
- order_quantity (주문수량) — bigint — NOT NULL
post (게시글)
- id (글id) — Primary key — NOT NULL
- title (제목) — varchar(255) — NOT NULL
- contents (내용) — varchar(3000)
post_author_list (글_회원_목록)
- id (Key) — bigint — Primary key — NOT NULL
- author_id (글쓴이ID) — bigint — Foreign key → author.id — NOT NULL
- post_id (글id) — Foreign key → post.id — NOT NULL
product (상품)
- ID (상품ID) — bigint — Primary key — NOT NULL
- product_name (상품명) — bigint — NOT NULL
- stock (재고) — bigint — NOT NULL
- prodcut_price (상품개당가격) — bigint — NOT NULL
user (회원)
- ID (회원ID) — bigint — Primary key — NOT NULL
- name (회원이름) — bigint — NOT NULL
- email (이메일) — bigint — NOT NULL
- password (Field3) — bigint — NOT NULL
- roll (사용자구분) — bigint — NOT NULL