timedeal

Tables (11)

Administrator (관리자)

  • administrator_id (관리자PK) — Long — Primary key — NOT NULL
  • username (아이디) — varchar
  • password (비밀번호) — varchar

Consumer (소비자)

  • consumer_id (소비자Pk) — Long — Primary key — NOT NULL
  • username (아이디) — varchar
  • password (비밀번호) — varchar
  • address (주소) — varchar

Event (이벤트)

  • event_id (이벤트아이디) — Long — Primary key — NOT NULL
  • administrator_id (관리자PK) — Long — Foreign key → Administrator.administrator_id — NOT NULL
  • event_type (이벤트타입) — varchar

Order (주문)

  • order_id (주문아이디) — Long — Primary key — NOT NULL
  • consumer_id (물건을구매한사람) — Long — Foreign key → Consumer.consumer_id — NOT NULL
  • order_total_price (주문 총 가격) — int
  • order_real_price (주문 판매 가격) — int
  • order_status (주문상태) — varchar

OrderItem (주문상품)

  • order_item_id (주문상품아이디) — Long — Primary key — NOT NULL
  • order_id (주문아이디) — Long — Foreign key → Order.order_id — NOT NULL
  • product_id (상품아이디) — Long — Foreign key → Product.product_id — NOT NULL
  • item_price (상품 원 가격) — int
  • publish_event_id (적용된 이벤트 아이디) — Long
  • item_real_price (상품 판매가격) — int

Post_Scrap (Untitled)

  • Post_Scrap_Id (Long) — Long — Primary key — NOT NULL
  • Post_View_Id (Key) — Long — Foreign key → Post_View.Post_View_Id — NOT NULL
  • User_Id (Key2) — Long — Foreign key → User.User_Id — NOT NULL
  • download_status (Field) — varchar
  • post_title (Field2) — varchar
  • post_description (Field3) — varchar
  • origin_content_url (Field4) — varchar
  • download_content_url (Field5) — varchar
  • thumbnail_url (Field6) — varchar

Post_View (Untitled2)

  • Post_View_Id (Key) — Long — Primary key — NOT NULL
  • view_count (Field) — Long

Product (상품)

  • product_id (상품아이디) — Long — Primary key — NOT NULL
  • administrator_id (만든사람) — Long — Foreign key → Administrator.administrator_id — NOT NULL
  • product_name (상품이름) — varchar
  • product_price (상품가격) — int
  • description (상품설명) — varchar

ProductEvent (이벤트상품)

  • product_event_id (상품이벤트아이디) — Long — Primary key — NOT NULL
  • publish_event_id (이벤트발행아이디) — Long — Foreign key → PublishEvent.publish_event_id — NOT NULL
  • product_id (상품아이디) — Long — Foreign key → Product.product_id — NOT NULL

PublishEvent (이벤트발행)

  • publish_event_id (이벤트발행아이디) — Long — Primary key — NOT NULL
  • event_id (이벤트아이디) — Long — Foreign key → Event.event_id — NOT NULL
  • event_name (이벤트명) — varchar
  • event_start_time (이벤트시작시각) — Date
  • event_end_time (이벤트종료시각) — Date
  • event_desc (이벤트혜택) — int
  • event_code (이벤트발행코드) — varchar

User (Untitled3)

  • User_Id (Key) — Long — Primary key — NOT NULL
  • user_name (Field) — varchar