ssafyFirst

Tables (4)

purchaseInfo(Todo) (Untitled3)

  • purchaseid (Key) — char(32) — Primary key — NOT NULL
  • buyer (Key2) — varchar(16) — Primary key — NOT NULL
  • resultcode (Field) — varchar(16)
  • purchasetype (Field2) — int
  • total (Field3) — int
  • purchasedate (Field4) — date

subTitleInfo(Todo) (Untitled2)

  • subid (Key) — char(8) — Primary key — NOT NULL
  • subname (Field) — varchar(128)
  • subdiscription (Field2) — varchar(256)
  • country (Field3) — varchar(128)
  • runtime (Field4) — time
  • registday (Field5) — date

userInfo (user)

  • uid — char(8) — Primary key — NOT NULL
  • email — varchar(128)
  • password — varchar(128)
  • create_date — datetime

userInfo(Todo) (Untitled)

  • buyer (Key) — varchar(16) — Primary key — NOT NULL
  • coupon (Field) — varchar(32)
  • remainPoint (Field2) — int
  • actTime (Field3) — time
  • level (Field4) — varchar(12)