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