forcampus
Tables (10)
admin (Untitled8)
- Key — Primary key — NOT NULL
- id (Field)
- pw (Field2)
- last_login_at (Field3)
- login_ip (Field4)
brand (Untitled)
- id (pk) — Primary key — NOT NULL
- name (Field)
- commission_rate (Field2)
- is_active (Field3)
campaign (Untitled4)
- id (pk) — Primary key — NOT NULL
- title (Field)
- status (Field2)
- description (Field3)
- created_at (Field4)
- start_at (Field5)
- end_at (Field6)
- img (Field8)
- brand_id (fk) — Foreign key → brand.id — NOT NULL
- universities_id (Key) — Foreign key → universities.id — NOT NULL
- url (Field7)
campaign_products (Untitled3)
- id (pk) — Primary key — NOT NULL
- package_name (Field)
- sale_price (Field2)
- package_quantity (Field3)
- campaign_id (fk) — Foreign key → campaign.id — NOT NULL
erp_products (ERP 원천상품)
- id (pk) — Primary key — NOT NULL
- brand_id (fk)
- name (Field2)
- base_cost (Field3)
- brand_id (pk2) — Foreign key → brand.id — NOT NULL
order_items (주문서/발주서)
- id (Key) — Primary key — NOT NULL
- quantity (Field)
- total_erp_quantity (Field2)
- Field3
- orders_id (pk) — Foreign key → orders.id — NOT NULL
- product_option_id (Key2) — Foreign key → product_option.id — NOT NULL
orders (Untitled5)
- id (pk) — Primary key — NOT NULL
- buyer_name (Field)
- total_amount (Field2)
- created_at (Field4)
- order_status (Field5)
- phone_number (Field6)
- address (Field7)
- zip_code (Field8)
- campaign_id (fk) — Foreign key → campaign.id — NOT NULL
- payment_url (Field3)
product_option (Untitled2)
- id (Key) — Primary key — NOT NULL
- display_name (Field)
- erp_product_id (pk) — Foreign key → erp_products.id — NOT NULL
- campaign_products_id (pk2) — Foreign key → campaign_products.id — NOT NULL
universities (Untitled6)
- id (Key) — Primary key — NOT NULL
- name (Field)
- is_active (Field2)