연예인 통합 서비스
테이블 (10)
Cart
- cartId — INT — NOT NULL
- userId — INT
- itemId — INT
- itemCnt — INT
- addDate — TIMESTAMP
Celebrity
- Cele_ID — INT — NOT NULL
- Name — VARCHAR(255)
- Email — VARCHAR(255)
- Profile — VARCHAR(255)
- Password — VARCHAR(255)
Comments
- ID — INT — NOT NULL
- Post_id — INT
- user_id — INT
- content — TEXT
- created_at — TIMESTAMP
Goods
- itemId — INT — NOT NULL
- Price — INT
- Quantity — INT
- Name — VARCHAR(200)
Like
- UniqueID — INT — NOT NULL
- user_id — INT
- post_id — INT
- created_at — TIMESTAMP
Message
- Msg_ID — INT — NOT NULL
- Cele_ID — INT
- Content — TEXT
- created_at — TIMESTAMP
Order
- UniqueID — INT — NOT NULL
- User_ID — INT
- Price — INT
- Amount — INT
- OrderDate — TIMESTAMP
- item_ID — INT
Post
- ID — INT — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- content_url — VARCHAR(255)
- Cele_ID — INT
- created_at — BIGINT
User
- ID — INT — 기본 키 — NOT NULL
- email — VARCHAR(255)
- username — VARCHAR(255)
- password — VARCHAR(255)
- role — VARCHAR(50)
- created_at — TIMESTAMP
UserPage
- ID — INT — 기본 키 — NOT NULL
- liked_posts — TEXT
- order_history — TEXT