SDP1617-project
Tables (4)
CardImage (카드 이미지)
- card_image_id (Key) — BIGINT — Primary key — NOT NULL
- presinged_url (Field)
- file_url (Field2)
- card_id (Key2) — BIGINT — Foreign key → Cards.card_id — NOT NULL
Cards (마음 카드)
- card_id (Key) — BIGINT — Primary key — NOT NULL
- title (Field3) — VARCHAR(100)
- card_design (Field) — ENUM
- category (Field2) — ENUM
- link (Field4) — VARCHAR(100)
- link_title (Field5) — VARCHAR(100)
- content (Field6) — VARCHAR(500)
- envelop_id (Key2) — BIGNIT — Foreign key → Envelop.envelop_id — NOT NULL
Envelop (봉투)
- envelop_id (Key) — BIGINT — Primary key — NOT NULL
- receiver_id (Field2) — BIGINT
- design_type (Field) — ENUM
- sender_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL
- receiver_id (Field3) — BIGINT
User (Untitled)
- user_id (Key) — BIGINT — Primary key — NOT NULL
- Field