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