PROJECT
Tables (4)
IDEA
- seq (Key) — INT — Primary key — NOT NULL
- project_name (Field) — VARCHAR(20)
- short_description (Field2) — VARCHAR(50)
- purchase_status (Field3) — NUMBER
- thumbnail_image (Field4) — VARCHAR(100)
- category (Field5) — VARCHAR(20)
- motivation (Field6) — VARCHAR(1000)
- need (Field7) — VARCHAR(1000)
- strategy (Field8) — VARCHAR(1000)
- market_analysis (Field9) — VARCHAR(1000)
- competitivenes (Field10) — VARCHAR(1000)
- open_level (Field11) — NUMBER
- id (Key2) — VARHCAR(20) — Foreign key → USERS.id — NOT NULL
LIKEY
- user_id (Key) — VARHCAR(20) — Foreign key → USERS.id — NOT NULL
- seq (Key2) — INT — Foreign key → IDEA.seq — NOT NULL
PURCHASE
- user_id (Key) — VARHCAR(20) — Foreign key → USERS.id — NOT NULL
- seq (Key2) — INT — Foreign key → IDEA.seq — NOT NULL
- purchase_level (Field) — INT
USERS
- id (Key) — VARHCAR(20) — Primary key — NOT NULL
- password (Field) — VARCHAR(20)
- name (Field2) — VARCHAR(20)
- age (Field3) — INT
- phone (Field4) — VARCHAR(30)
- address (Field5) — VARCHAR(50)
- email (Field6) — VARCHAR(30)