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