test
Tables (7)
COMMENTS (댓글)
- comment_id (Key) — integer — Primary key — NOT NULL
- post_id (Key2) — integer — Foreign key → POSTS.post_id — NOT NULL
- user_id (Key3) — integer — Foreign key → POSTS.user_id — NOT NULL
- user_name (Key22) — Foreign key → POSTS.user_name — NOT NULL
- comment_content (Field2) — string
- create_at (Field3) — integer
COUPONS (Untitled)
- coupon_id (Key) — Primary key — NOT NULL
- user_id (Field)
- coupon_discount_rate (Field2)
- coupon_state (Field3)
- create_at (Field4)
COURSES (코스)
- course_id (Key) — integer — Primary key — NOT NULL
- course_name (Field) — string
- course_latitude (Field2) — string
- course_longitude (Field3) — string
- course_QR (Field4) — string
POSTS (게시글)
- post_id (Key) — integer — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → USERS.user_id — NOT NULL
- user_name (Key22) — Foreign key → USERS.user_name — NOT NULL
- post_title (Field) — string
- post_content (Field2) — string
- create_at (Field3) — integer
POST_IMAGES (게시글 이미지)
- image_id (Key) — integer — Primary key — NOT NULL
- post_id (Key2) — integer — Foreign key → POSTS.post_id — NOT NULL
- Key2 (Key22) — Foreign key → POSTS.user_name — NOT NULL
- image_path (Field) — string
- image_name (Field2) — string
- image_type (Field3) — string
STAMPS (스탬프)
- stamp_id (Key) — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → USERS.user_id — NOT NULL
- stamp_location (Field)
- stamp_type (Field2)
- create_at (Field3)
USERS (유저)
- user_id (Key) — integer — Primary key — NOT NULL
- user_name (Key2) — string — Primary key — NOT NULL
- user_login_id (Field) — string
- user_login_pw (Field2) — string
- create_at (Field4) — integer